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.PER_ZA_WSP_XML_GEN_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 280: , pay_assignment_actions paa

276: -- changed action_context_type from PA to AAP
277: cursor csr_wsp_occ is
278: select pai.action_information6 occ_cat
279: from pay_payroll_actions ppa
280: , pay_assignment_actions paa
281: , pay_action_information pai
282: where ppa.payroll_action_id = p_payroll_action_id
283: AND paa.payroll_action_id = ppa.payroll_action_id
284: AND pai.action_context_id = paa.assignment_action_id

Line 296: , pay_assignment_actions paa

292: , pai.action_information4 race
293: , pai.action_information5 sex
294: , pai.action_information7 disability
295: from pay_payroll_actions ppa
296: , pay_assignment_actions paa
297: , pay_action_information pai
298: where ppa.payroll_action_id = p_payroll_action_id
299: AND paa.payroll_action_id = ppa.payroll_action_id
300: AND pai.action_context_id = paa.assignment_action_id

Line 309: , pay_assignment_actions paa

305:
306: cursor csr_wsp_occ_sk_prs( p_occ_cat varchar) is
307: select distinct pai.action_information11 sk_pr_num
308: from pay_payroll_actions ppa
309: , pay_assignment_actions paa
310: , pay_action_information pai
311: where ppa.payroll_action_id = p_payroll_action_id
312: AND paa.payroll_action_id = ppa.payroll_action_id
313: AND pai.action_context_id = paa.assignment_action_id

Line 611: , pay_assignment_actions paa

607:
608: cursor csr_atr_occ is
609: select action_information6 occ_cat
610: from pay_payroll_actions ppa
611: , pay_assignment_actions paa
612: , pay_action_information pai
613: where ppa.payroll_action_id = p_payroll_action_id
614: AND paa.payroll_action_id = ppa.payroll_action_id
615: AND pai.action_context_id = paa.assignment_action_id

Line 628: , pay_assignment_actions paa

624: , action_information5 sex
625: , action_information7 disability
626: , action_information14 status
627: from pay_payroll_actions ppa
628: , pay_assignment_actions paa
629: , pay_action_information pai
630: where ppa.payroll_action_id = p_payroll_action_id
631: AND paa.payroll_action_id = ppa.payroll_action_id
632: AND pai.action_context_id = paa.assignment_action_id

Line 641: , pay_assignment_actions paa

637:
638: cursor csr_atr_occ_sk_prs( p_occ_cat varchar) is
639: select distinct action_information11 sk_pr_num
640: from pay_payroll_actions ppa
641: , pay_assignment_actions paa
642: , pay_action_information pai
643: where ppa.payroll_action_id = p_payroll_action_id
644: AND paa.payroll_action_id = ppa.payroll_action_id
645: AND pai.action_context_id = paa.assignment_action_id