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_ACTION_INFORMATION

Line 150: from pay_action_information

146: , action_information17 phy_province
147: , action_information18 tel_no -- A(1).5 Telephone number
148: , action_information19 fax_no -- A(1).6 Fax number
149: , action_information20 email_add -- A(1).7 E-mail Address
150: from pay_action_information
151: where action_context_id = p_payroll_action_id
152: and action_information_category = 'ZA WSP EMPLOYER DETAILS'
153: and action_information2 = p_legal_entity_id
154: and action_context_type = 'PA';

Line 170: from pay_action_information

166: , action_information10 sdf_tel -- A(1).14 SDF contact details
167: , action_information11 sdf_mobile
168: , action_information12 sdf_fax
169: , action_information13 sdf_email
170: from pay_action_information
171: where action_context_id = p_payroll_action_id
172: and action_information_category = 'ZA WSP SDF DETAILS'
173: and action_information2 = p_legal_entity_id
174: and action_context_type = 'PA';

Line 262: from pay_action_information

258: , action_information14 saqa_yes
259: , action_information15 saqa_no
260: , action_information16 saqa_id
261: , action_information17 year
262: from pay_action_information
263: where action_context_id = p_payroll_action_id
264: and action_information_category = 'ZA WSP TRAINING PROGRAMS'
265: and action_information2 = p_legal_entity_id
266: and action_context_type = 'PA'

Line 274: , pay_action_information pai

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
278: and pai.action_information_category = 'ZA WSP PERSON DETAILS'

Line 290: , pay_action_information pai

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
294: and pai.action_information_category = 'ZA WSP PERSON DETAILS'

Line 303: , pay_action_information pai

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
307: and pai.action_information_category = 'ZA WSP PERSON DETAILS'

Line 594: from pay_action_information

590: , action_information14 saqa_yes
591: , action_information15 saqa_no
592: , action_information16 saqa_id
593: , action_information17 year
594: from pay_action_information
595: where action_context_id = p_payroll_action_id
596: and action_information_category = 'ZA ATR TRAINING PROGRAMS'
597: and action_information2 = p_legal_entity_id
598: and action_context_type = 'PA'

Line 605: , pay_action_information pai

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
609: and pai.action_information_category = 'ZA ATR PERSON DETAILS'

Line 622: , pay_action_information pai

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
626: and pai.action_information_category = 'ZA ATR PERSON DETAILS'

Line 635: , pay_action_information pai

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
639: and pai.action_information_category = 'ZA ATR PERSON DETAILS'

Line 1013: from pay_action_information

1009: item_text xmldom.DOMText;
1010:
1011: cursor csr_legal_entities is
1012: select distinct action_information2 legal_entity_id -- Legal entity ID
1013: from pay_action_information
1014: where action_context_id = p_payroll_action_id
1015: and action_information1 = p_business_group_id
1016: and action_information2 = nvl(p_legal_entity_id, action_information2)
1017: and action_information_category = 'ZA WSP EMPLOYER DETAILS'