PA Standard Rate Schedules

Description
Categories: BI Publisher
Columns: Std Bill Rate Schedule, Bill Rate Organization Id, Employee, Employee Number, Markup Percentage, Rate, Unit, Start Date, End Date ...
Application: Projects
Source: IMP: Standard Rate Schedules (XML)
Short Name: PAXRWSBR_XML
DB package: PA_PAXRWSBR_XMLP_PKG
SELECT
         br.std_bill_rate_schedule,
         br.bill_rate_organization_id,
         p.full_name employee,
         decode(p.current_npw_flag,'Y',p.npw_number,p.employee_number) employee_number,
         br.markup_percentage,
         br.rate,
         u.meaning unit,
         br.start_date_active start_date,
         br.end_date_active end_date
FROM
         per_people_f  p,
         pa_lookups u,
         pa_bill_rates br
WHERE
         br.person_id = p.person_id
and      br.bill_rate_unit = u.lookup_code (+)
and      u.lookup_type (+) = 'UNIT'
and     nvl(:effective_date,br.start_date_active)
        between br.start_date_active
        and      nvl(br.end_date_active,
                     nvl(:effective_date,br.start_date_active))
and     :schedule_type = 'EMPLOYEE'
and     sysdate between p.effective_start_date and p.effective_end_date
and    ( p.employee_number IS NOT NULL  OR p.npw_number IS NOT NULL ) 
 and br.std_bill_rate_schedule=:std_bill_rate_schedule_q_rate 
 and br.bill_rate_organization_id=:organization_id_q_rate
order by p.full_name, br.start_date_active
Parameter Name SQL text Validation
Organization
 
LOV Oracle
Standard Rate Schedule
 
LOV Oracle
Effective Date
 
Date