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 155: from pay_action_information

151: , action_information18 tel_no -- A(1).5 Telephone number
152: , action_information19 fax_no -- A(1).6 Fax number
153: , action_information20 email_add -- A(1).7 E-mail Address
154: , action_information23 sdl_no
155: from pay_action_information
156: where action_context_id = p_payroll_action_id
157: and action_information_category = 'ZA WSP EMPLOYER DETAILS'
158: and action_information2 = p_legal_entity_id
159: and action_context_type = 'PA';

Line 175: from pay_action_information

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

Line 269: from pay_action_information

265: , action_information14 saqa_yes
266: , action_information15 saqa_no
267: , action_information16 saqa_id
268: , action_information17 year
269: from pay_action_information
270: where action_context_id = p_payroll_action_id
271: and action_information_category = 'ZA WSP TRAINING PROGRAMS'
272: and action_information2 = p_legal_entity_id
273: and action_context_type = 'PA'

Line 281: , pay_action_information pai

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

Line 297: , pay_action_information pai

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

Line 310: , pay_action_information pai

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

Line 601: from pay_action_information

597: , action_information14 saqa_yes
598: , action_information15 saqa_no
599: , action_information16 saqa_id
600: , action_information17 year
601: from pay_action_information
602: where action_context_id = p_payroll_action_id
603: and action_information_category = 'ZA ATR TRAINING PROGRAMS'
604: and action_information2 = p_legal_entity_id
605: and action_context_type = 'PA'

Line 612: , pay_action_information pai

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

Line 629: , pay_action_information pai

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

Line 642: , pay_action_information pai

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

Line 1020: from pay_action_information

1016: item_text xmldom.DOMText;
1017:
1018: cursor csr_legal_entities is
1019: select distinct action_information2 legal_entity_id -- Legal entity ID
1020: from pay_action_information
1021: where action_context_id = p_payroll_action_id
1022: and action_information1 = p_business_group_id
1023: and action_information2 = nvl(p_legal_entity_id, action_information2)
1024: and action_information_category = 'ZA WSP EMPLOYER DETAILS'