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_NL_PGGM_PENSION_EXTRACTS dependencies on PAY_PAYROLL_ACTIONS

Line 237: ,pay_payroll_actions ppa

233: SELECT paa.assignment_action_id
234: ,ppa.effective_date
235: ,ppa.action_type
236: FROM pay_assignment_actions paa
237: ,pay_payroll_actions ppa
238: WHERE paa.assignment_id = c_assignment_id
239: AND paa.payroll_action_id = ppa.payroll_action_id
240: AND paa.source_action_id IS NULL
241: AND ppa.action_status = 'C'

Line 4578: ,pay_payroll_actions ppa

4574: IS
4575: SELECT paa.assignment_action_id
4576: ,ppa.date_earned
4577: FROM pay_assignment_actions paa
4578: ,pay_payroll_actions ppa
4579: WHERE paa.assignment_id = c_assignment_id
4580: AND paa.payroll_action_id = ppa.payroll_action_id
4581: AND paa.source_action_id IS NOT NULL
4582: AND ppa.action_status = 'C'

Line 6565: FROM pay_payroll_actions ppa,

6561: --late hire scenarios etc. are met
6562: CURSOR csr_chk_new_hire (c_assignment_id IN Number
6563: ) IS
6564: SELECT MIN(ppa.effective_date)
6565: FROM pay_payroll_actions ppa,
6566: pay_assignment_actions paa
6567: WHERE paa.assignment_id = c_assignment_id
6568: AND paa.payroll_action_id = ppa.payroll_action_id
6569: AND paa.action_status = 'C'