eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_PAY_PROPOSALS

Line 3955: FROM per_pay_proposals ppp

3951: ,c_effective_date IN DATE
3952: ,c_business_group_id IN NUMBER) IS
3953:
3954: SELECT ppp.proposed_salary_n
3955: FROM per_pay_proposals ppp
3956: WHERE ppp.assignment_id = c_assignment_id
3957: AND ppp.business_group_id = c_business_group_id
3958: AND ppp.change_date = (SELECT MAX(ppx.change_date)
3959: FROM per_pay_proposals ppx

Line 3959: FROM per_pay_proposals ppx

3955: FROM per_pay_proposals ppp
3956: WHERE ppp.assignment_id = c_assignment_id
3957: AND ppp.business_group_id = c_business_group_id
3958: AND ppp.change_date = (SELECT MAX(ppx.change_date)
3959: FROM per_pay_proposals ppx
3960: WHERE ppx.assignment_id = ppp.assignment_id
3961: AND ppx.business_group_id = ppp.business_group_id
3962: AND ppx.change_date <= c_effective_date
3963: AND ppx.approved = 'Y');