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 273: , pay_assignment_actions paa

269: -- changed action_context_type from PA to AAP
270: cursor csr_wsp_occ is
271: select pai.action_information6 occ_cat
272: from pay_payroll_actions ppa
273: , pay_assignment_actions paa
274: , pay_action_information pai
275: where ppa.payroll_action_id = p_payroll_action_id
276: AND paa.payroll_action_id = ppa.payroll_action_id
277: AND pai.action_context_id = paa.assignment_action_id

Line 289: , pay_assignment_actions paa

285: , pai.action_information4 race
286: , pai.action_information5 sex
287: , pai.action_information7 disability
288: from pay_payroll_actions ppa
289: , pay_assignment_actions paa
290: , pay_action_information pai
291: where ppa.payroll_action_id = p_payroll_action_id
292: AND paa.payroll_action_id = ppa.payroll_action_id
293: AND pai.action_context_id = paa.assignment_action_id

Line 302: , pay_assignment_actions paa

298:
299: cursor csr_wsp_occ_sk_prs( p_occ_cat varchar) is
300: select distinct pai.action_information11 sk_pr_num
301: from pay_payroll_actions ppa
302: , pay_assignment_actions paa
303: , pay_action_information pai
304: where ppa.payroll_action_id = p_payroll_action_id
305: AND paa.payroll_action_id = ppa.payroll_action_id
306: AND pai.action_context_id = paa.assignment_action_id

Line 604: , pay_assignment_actions paa

600:
601: cursor csr_atr_occ is
602: select action_information6 occ_cat
603: from pay_payroll_actions ppa
604: , pay_assignment_actions paa
605: , pay_action_information pai
606: where ppa.payroll_action_id = p_payroll_action_id
607: AND paa.payroll_action_id = ppa.payroll_action_id
608: AND pai.action_context_id = paa.assignment_action_id

Line 621: , pay_assignment_actions paa

617: , action_information5 sex
618: , action_information7 disability
619: , action_information14 status
620: from pay_payroll_actions ppa
621: , pay_assignment_actions paa
622: , pay_action_information pai
623: where ppa.payroll_action_id = p_payroll_action_id
624: AND paa.payroll_action_id = ppa.payroll_action_id
625: AND pai.action_context_id = paa.assignment_action_id

Line 634: , pay_assignment_actions paa

630:
631: cursor csr_atr_occ_sk_prs( p_occ_cat varchar) is
632: select distinct action_information11 sk_pr_num
633: from pay_payroll_actions ppa
634: , pay_assignment_actions paa
635: , pay_action_information pai
636: where ppa.payroll_action_id = p_payroll_action_id
637: AND paa.payroll_action_id = ppa.payroll_action_id
638: AND pai.action_context_id = paa.assignment_action_id