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.PAY_ZA_UIF_MAGTAPE_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 58: where pai.action_information1 = pay_magtape_generic.get_parameter_value('BG_ID')

54: 'TRANSFER_CONTACT_NUMBER=P' , nvl(pai.action_information6, '&&&'),
55: 'TRANSFER_CONTACT_EMAIL_ADDRESS=P' , nvl(pai.action_information7, '&&&')
56: from pay_action_information pai
57: , pay_payroll_actions ppa
58: where pai.action_information1 = pay_magtape_generic.get_parameter_value('BG_ID')
59: and pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')
60: and pai.action_information_category = 'ZA UIF CREATOR DETAILS'
61: and pai.action_context_type = 'PA'
62: and pai.action_context_id = ppa.payroll_action_id

Line 59: and pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')

55: 'TRANSFER_CONTACT_EMAIL_ADDRESS=P' , nvl(pai.action_information7, '&&&')
56: from pay_action_information pai
57: , pay_payroll_actions ppa
58: where pai.action_information1 = pay_magtape_generic.get_parameter_value('BG_ID')
59: and pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')
60: and pai.action_information_category = 'ZA UIF CREATOR DETAILS'
61: and pai.action_context_type = 'PA'
62: and pai.action_context_id = ppa.payroll_action_id
63: and ppa.rowid =

Line 71: = pay_magtape_generic.get_parameter_value('CAL_MONTH')

67: , -length(ppa2.rowid)
68: )
69: from pay_payroll_actions ppa2
70: where to_char(to_date(pay_za_uif_archive_pkg.get_parameter('END_DATE', ppa2.legislative_parameters), 'YYYY/MM/DD'), 'YYYYMM')
71: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
72: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('BG_ID')
73: and ppa2.action_type = 'X'
74: and ppa2.report_type = 'ZA_UIF'
75: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),

Line 72: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('BG_ID')

68: )
69: from pay_payroll_actions ppa2
70: where to_char(to_date(pay_za_uif_archive_pkg.get_parameter('END_DATE', ppa2.legislative_parameters), 'YYYY/MM/DD'), 'YYYYMM')
71: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
72: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('BG_ID')
73: and ppa2.action_type = 'X'
74: and ppa2.report_type = 'ZA_UIF'
75: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),
76: ppa2.payroll_action_id)

Line 75: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),

71: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
72: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('BG_ID')
73: and ppa2.action_type = 'X'
74: and ppa2.report_type = 'ZA_UIF'
75: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),
76: ppa2.payroll_action_id)
77: group by length(ppa2.rowid)
78: );
79:

Line 95: where pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')

91:
92: from pay_action_information pai
93: , pay_payroll_actions ppa
94: , pay_assignment_actions paa
95: where pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')
96: and pai.action_context_type = 'AAP'
97: and pai.action_information_category = 'ZA UIF EMPLOYEE DETAILS'
98: and pai.action_context_id = paa.assignment_action_id
99: and paa.payroll_action_id = ppa.payroll_action_id

Line 105: = pay_magtape_generic.get_parameter_value('CAL_MONTH')

101: (
102: select ppa2.payroll_action_id
103: from pay_payroll_actions ppa2
104: where to_char(to_date(pay_za_uif_archive_pkg.get_parameter('END_DATE', ppa2.legislative_parameters), 'YYYY/MM/DD'), 'YYYYMM')
105: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
106: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')
107: and ppa2.action_type = 'X'
108: and ppa2.report_type = 'ZA_UIF'
109: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),

Line 106: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')

102: select ppa2.payroll_action_id
103: from pay_payroll_actions ppa2
104: where to_char(to_date(pay_za_uif_archive_pkg.get_parameter('END_DATE', ppa2.legislative_parameters), 'YYYY/MM/DD'), 'YYYYMM')
105: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
106: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')
107: and ppa2.action_type = 'X'
108: and ppa2.report_type = 'ZA_UIF'
109: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),
110: ppa2.payroll_action_id)

Line 109: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),

105: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
106: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')
107: and ppa2.action_type = 'X'
108: and ppa2.report_type = 'ZA_UIF'
109: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),
110: ppa2.payroll_action_id)
111: )
112: group by pai.action_information4 /*UIF Employer Ref No*/
113: , pai.action_information5 /*PAYE Employer Number*/

Line 152: = pay_magtape_generic.get_parameter_value('CAL_MONTH')

148: from pay_assignment_actions paa2
149: , pay_payroll_actions ppa2
150: where ppa2.payroll_action_id = paa2.payroll_action_id
151: and to_char(to_date(pay_za_uif_archive_pkg.get_parameter('END_DATE', ppa2.legislative_parameters), 'YYYY/MM/DD'), 'YYYYMM')
152: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
153: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')
154: and ppa2.action_type = 'X'
155: and ppa2.report_type = 'ZA_UIF'
156: and paa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),

Line 153: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')

149: , pay_payroll_actions ppa2
150: where ppa2.payroll_action_id = paa2.payroll_action_id
151: and to_char(to_date(pay_za_uif_archive_pkg.get_parameter('END_DATE', ppa2.legislative_parameters), 'YYYY/MM/DD'), 'YYYYMM')
152: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
153: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')
154: and ppa2.action_type = 'X'
155: and ppa2.report_type = 'ZA_UIF'
156: and paa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),
157: ppa2.payroll_action_id)

Line 156: and paa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),

152: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
153: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')
154: and ppa2.action_type = 'X'
155: and ppa2.report_type = 'ZA_UIF'
156: and paa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),
157: ppa2.payroll_action_id)
158: group by length(paa2.rowid) , paa2.assignment_id
159: ) paa_v
160: where pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')

Line 160: where pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')

156: and paa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),
157: ppa2.payroll_action_id)
158: group by length(paa2.rowid) , paa2.assignment_id
159: ) paa_v
160: where pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')
161: and pai.action_information4 = pay_magtape_generic.get_parameter_value('TRANSFER_UIF_EMPL_REF_NO')
162: and pai.action_context_id = paa.assignment_action_id
163: and pai.action_context_type = 'AAP'
164: and pai.action_information_category = 'ZA UIF EMPLOYEE DETAILS'

Line 161: and pai.action_information4 = pay_magtape_generic.get_parameter_value('TRANSFER_UIF_EMPL_REF_NO')

157: ppa2.payroll_action_id)
158: group by length(paa2.rowid) , paa2.assignment_id
159: ) paa_v
160: where pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')
161: and pai.action_information4 = pay_magtape_generic.get_parameter_value('TRANSFER_UIF_EMPL_REF_NO')
162: and pai.action_context_id = paa.assignment_action_id
163: and pai.action_context_type = 'AAP'
164: and pai.action_information_category = 'ZA UIF EMPLOYEE DETAILS'
165: and paa.rowid = paa_v.paa_rowid

Line 191: where pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')

187: 'TRANSFER_BANK_ACCOUNT_NUMBER=P' , nvl(pai.action_information20, '&&&'),
188: 'TRANSFER_BANK_ACCOUNT_TYPE=P' , nvl(pai.action_information21, '&&&')
189: from pay_action_information pai
190: , pay_assignment_actions paa
191: where pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')
192: and pai.action_context_type = 'AAP'
193: and pai.action_information4 = pay_magtape_generic.get_parameter_value('TRANSFER_UIF_EMPL_REF_NO')
194: and pai.action_information_category = 'ZA UIF EMPLOYEE DETAILS'
195: and pai.action_context_id = paa.assignment_action_id

Line 193: and pai.action_information4 = pay_magtape_generic.get_parameter_value('TRANSFER_UIF_EMPL_REF_NO')

189: from pay_action_information pai
190: , pay_assignment_actions paa
191: where pai.action_information2 = pay_magtape_generic.get_parameter_value('CAL_MONTH')
192: and pai.action_context_type = 'AAP'
193: and pai.action_information4 = pay_magtape_generic.get_parameter_value('TRANSFER_UIF_EMPL_REF_NO')
194: and pai.action_information_category = 'ZA UIF EMPLOYEE DETAILS'
195: and pai.action_context_id = paa.assignment_action_id
196: and paa.rowid =
197: (

Line 207: = pay_magtape_generic.get_parameter_value('CAL_MONTH')

203: , pay_payroll_actions ppa2
204: where paa2.assignment_id = paa.assignment_id
205: and ppa2.payroll_action_id = paa2.payroll_action_id
206: and to_char(to_date(pay_za_uif_archive_pkg.get_parameter('END_DATE', ppa2.legislative_parameters), 'YYYY/MM/DD'), 'YYYYMM')
207: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
208: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')
209: and ppa2.action_type = 'X'
210: and ppa2.report_type = 'ZA_UIF'
211: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),

Line 208: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')

204: where paa2.assignment_id = paa.assignment_id
205: and ppa2.payroll_action_id = paa2.payroll_action_id
206: and to_char(to_date(pay_za_uif_archive_pkg.get_parameter('END_DATE', ppa2.legislative_parameters), 'YYYY/MM/DD'), 'YYYYMM')
207: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
208: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')
209: and ppa2.action_type = 'X'
210: and ppa2.report_type = 'ZA_UIF'
211: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),
212: ppa2.payroll_action_id)

Line 211: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),

207: = pay_magtape_generic.get_parameter_value('CAL_MONTH')
208: and ppa2.business_group_id = pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID')
209: and ppa2.action_type = 'X'
210: and ppa2.report_type = 'ZA_UIF'
211: and ppa2.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('TRANSFER_ARCH_PAYROLL_ACTION_ID'),
212: ppa2.payroll_action_id)
213: group by length(paa2.rowid)
214: )
215: order by pai.action_information8 */ /*Employee Number*/