PA Standard Rate Schedules
Description
Categories: BI Publisher
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
Run
PA Standard Rate Schedules and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |