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_PENSION_EXTRACTS dependencies on PER_PAY_PROPOSALS

Line 3228: FROM per_pay_proposals ppp

3224: ,c_effective_date IN DATE
3225: ,c_business_group_id IN NUMBER) IS
3226:
3227: SELECT ppp.proposed_salary_n
3228: FROM per_pay_proposals ppp
3229: WHERE ppp.assignment_id = c_assignment_id
3230: AND ppp.business_group_id = c_business_group_id
3231: AND ppp.change_date = (SELECT MAX(ppx.change_date)
3232: FROM per_pay_proposals ppx

Line 3232: FROM per_pay_proposals ppx

3228: FROM per_pay_proposals ppp
3229: WHERE ppp.assignment_id = c_assignment_id
3230: AND ppp.business_group_id = c_business_group_id
3231: AND ppp.change_date = (SELECT MAX(ppx.change_date)
3232: FROM per_pay_proposals ppx
3233: WHERE ppx.assignment_id = ppp.assignment_id
3234: AND ppx.business_group_id = ppp.business_group_id
3235: AND ppx.change_date <= c_effective_date
3236: AND ppx.approved = 'Y');