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_AU_TFN_MAGTAPE dependencies on PAY_MAGTAPE_GENERIC

Line 111: ,pay_magtape_generic.get_parameter_value('RUN_TYPE')

107: ,hou.name
108: ,'SUPPLIER_NUMBER=P'
109: ,hoi.org_information12
110: ,'RUN_TYPE=P'
111: ,pay_magtape_generic.get_parameter_value('RUN_TYPE')
112: ,'REPORT_END_DATE=P'
113: ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE')),'ddmmyyyy')
114: ,'GATEWAY_USER_ID=P'
115: ,NVL(hoi.org_information15,' ')

Line 113: ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE')),'ddmmyyyy')

109: ,hoi.org_information12
110: ,'RUN_TYPE=P'
111: ,pay_magtape_generic.get_parameter_value('RUN_TYPE')
112: ,'REPORT_END_DATE=P'
113: ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE')),'ddmmyyyy')
114: ,'GATEWAY_USER_ID=P'
115: ,NVL(hoi.org_information15,' ')
116: ,'SUPPLIER_NAME=P'
117: ,translate(hoi.org_information3,inv_character_string,blank_character_string)

Line 123: ,nvl(pay_magtape_generic.get_parameter_value('SUPP_FILE_REF'),' ')

119: ,translate(decode(pap.first_name,null,'',pap.first_name || ' ') || pap.last_name,inv_character_string,blank_character_string)
120: ,'TELEPHONE_NUMBER=P'
121: ,hoi.org_information14
122: ,'SUPP_FILE_REFERENCE=P'
123: ,nvl(pay_magtape_generic.get_parameter_value('SUPP_FILE_REF'),' ')
124: ,'STREET_ADDRESS1=P'
125: ,translate(nvl(hlc.address_line_1,' '),inv_character_string,blank_character_string)
126: ,'STREET_ADDRESS2=P'
127: ,translate(nvl(hlc.address_line_2,' '),inv_character_string,blank_character_string)

Line 143: WHERE hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

139: ,hr_locations_all hlc --Modified the table from hr_locations to hr_locations_all
140: ,fnd_territories_tl ftl
141: ,hr_organization_units hou
142: ,per_people_f pap
143: WHERE hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
144: AND hou.organization_id = hoi.organization_id
145: AND hoi.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')
146: AND hoi.org_information_context = 'AU_LEGAL_EMPLOYER'
147: AND ftl.territory_code = hlc.country

Line 145: AND hoi.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')

141: ,hr_organization_units hou
142: ,per_people_f pap
143: WHERE hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
144: AND hou.organization_id = hoi.organization_id
145: AND hoi.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')
146: AND hoi.org_information_context = 'AU_LEGAL_EMPLOYER'
147: AND ftl.territory_code = hlc.country
148: AND ftl.language(+) = userenv('LANG')
149: AND hlc.location_id(+) = hou.location_id

Line 155: fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'))

151: AND pap.effective_start_date = (SELECT max(effective_start_date)
152: FROM per_people_f p
153: WHERE pap.person_id=p.person_id
154: and p.effective_start_date <= /* 5474358 */
155: fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'))
156: group by p.person_id);
157:
158:
159:

Line 170: ,to_char(to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'ddmmyyyy')-14,'ddmmyyyy')/Bug 2974527/

166:
167: CURSOR C_TFN_PAYER IS
168: SELECT
169: 'REPORT_START_DATE=P'
170: ,to_char(to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'ddmmyyyy')-14,'ddmmyyyy')/*Bug 2974527*/
171: ,'REPORT_END_DATE=P'
172: ,pay_magtape_generic.get_parameter_value('REPORT_END_DATE')
173: ,'PAYER_ABN=P'
174: ,hoi.org_information12

Line 172: ,pay_magtape_generic.get_parameter_value('REPORT_END_DATE')

168: SELECT
169: 'REPORT_START_DATE=P'
170: ,to_char(to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'ddmmyyyy')-14,'ddmmyyyy')/*Bug 2974527*/
171: ,'REPORT_END_DATE=P'
172: ,pay_magtape_generic.get_parameter_value('REPORT_END_DATE')
173: ,'PAYER_ABN=P'
174: ,hoi.org_information12
175: ,'BRANCH_NUMBER=P'
176: ,nvl(hoi.org_information13,'001') /* Bug#5570822 Setting Branch number to 001 to avoid ECI checker error*/

Line 202: WHERE hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

198: ,hr_locations_all hlc --Modified the table from hr_locations to hr_locations_all
199: ,fnd_territories_tl ftl
200: ,hr_organization_units hou
201: ,per_people_f pap
202: WHERE hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
203: AND hou.organization_id = hoi.organization_id
204: AND hoi.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')
205: AND hoi.org_information_context = 'AU_LEGAL_EMPLOYER'
206: AND ftl.territory_code = hlc.country

Line 204: AND hoi.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')

200: ,hr_organization_units hou
201: ,per_people_f pap
202: WHERE hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
203: AND hou.organization_id = hoi.organization_id
204: AND hoi.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')
205: AND hoi.org_information_context = 'AU_LEGAL_EMPLOYER'
206: AND ftl.territory_code = hlc.country
207: AND ftl.language(+) = userenv('LANG')
208: AND hlc.location_id(+) = hou.location_id

Line 214: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY')

210: AND pap.effective_start_date = (SELECT max(effective_start_date)
211: FROM per_people_f p
212: WHERE pap.person_id=p.person_id
213: and p.effective_start_date <= /* 5474358 */
214: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY')
215: group by p.person_id );
216:
217:
218:

Line 303: AND pap.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

299: WHERE paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
300: AND ppa.report_type='AU_TFN_MAGTAPE' /*Bug4247686 */
301: AND ppa.report_qualifier='AU'
302: AND ppa.report_category='REPORT'
303: AND pap.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
304: AND hsc.segment1 = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')
305: AND pap.person_id = paa.person_id
306: AND pap.person_id = pad.person_id(+)
307: AND pad.primary_flag(+) = 'Y' /*Added for bug 2751147*/

Line 304: AND hsc.segment1 = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')

300: AND ppa.report_type='AU_TFN_MAGTAPE' /*Bug4247686 */
301: AND ppa.report_qualifier='AU'
302: AND ppa.report_category='REPORT'
303: AND pap.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
304: AND hsc.segment1 = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')
305: AND pap.person_id = paa.person_id
306: AND pap.person_id = pad.person_id(+)
307: AND pad.primary_flag(+) = 'Y' /*Added for bug 2751147*/
308: AND paa.effective_start_date = ( SELECT max(effective_Start_date)

Line 312: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY') /5474358 /

308: AND paa.effective_start_date = ( SELECT max(effective_Start_date)
309: FROM per_assignments_f a
310: WHERE a.assignment_id = paa.assignment_id
311: and a.effective_start_date < =
312: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY') /*5474358 */
313: group by a.assignment_id /*Bug4247686 */
314: )
315: AND pap.effective_start_date = ( SELECT max(effective_Start_date)
316: FROM per_people_f p

Line 319: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY') /5474358 /

315: AND pap.effective_start_date = ( SELECT max(effective_Start_date)
316: FROM per_people_f p
317: WHERE p.person_id = pap.person_id
318: and p.effective_start_date < =
319: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY') /*5474358 */
320: group by p.person_id /*Bug4247686 */
321: )
322: and sysdate between nvl(pad.date_from , sysdate) and nvl(pad.date_to ,sysdate) /* 4632219 */
323: AND ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 323: AND ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

319: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY') /*5474358 */
320: group by p.person_id /*Bug4247686 */
321: )
322: and sysdate between nvl(pad.date_from , sysdate) and nvl(pad.date_to ,sysdate) /* 4632219 */
323: AND ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
324: AND pac.payroll_action_id = ppa.payroll_action_id
325: AND pac.assignment_id = paa.assignment_id
326: ORDER BY pap.employee_number ;
327: