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 ...
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
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 |