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_ASSIGNMENT_ACTIONS

Line 236: FROM pay_assignment_actions paa

232: ) IS
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

Line 4577: FROM pay_assignment_actions paa

4573: )
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

Line 6566: pay_assignment_actions paa

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'
6570: AND ppa.action_type IN ('R', 'Q', 'I', 'B', 'V');