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 107: ,pay_magtape_generic.get_parameter_value('RUN_TYPE')

103: ,hou.name
104: ,'SUPPLIER_NUMBER=P'
105: ,hoi.org_information12
106: ,'RUN_TYPE=P'
107: ,pay_magtape_generic.get_parameter_value('RUN_TYPE')
108: ,'REPORT_END_DATE=P'
109: ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE')),'ddmmyyyy')
110: ,'GATEWAY_USER_ID=P'
111: ,NVL(hoi.org_information15,' ')

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

105: ,hoi.org_information12
106: ,'RUN_TYPE=P'
107: ,pay_magtape_generic.get_parameter_value('RUN_TYPE')
108: ,'REPORT_END_DATE=P'
109: ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE')),'ddmmyyyy')
110: ,'GATEWAY_USER_ID=P'
111: ,NVL(hoi.org_information15,' ')
112: ,'SUPPLIER_NAME=P'
113: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(hoi.org_information3,inv_character_string,blank_character_string)) /*Bug 9000052*/

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

115: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(decode(pap.first_name,null,'',pap.first_name || ' ') || pap.last_name,inv_character_string,blank_character_string)) /*Bug 9000052*/
116: ,'TELEPHONE_NUMBER=P'
117: ,hoi.org_information14
118: ,'SUPP_FILE_REFERENCE=P'
119: ,nvl(pay_magtape_generic.get_parameter_value('SUPP_FILE_REF'),' ')
120: ,'STREET_ADDRESS1=P'
121: ,translate(nvl(hlc.address_line_1,' '),inv_character_string,blank_character_string)
122: ,'STREET_ADDRESS2=P'
123: ,translate(nvl(hlc.address_line_2,' '),inv_character_string,blank_character_string)

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

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

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

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

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

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

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

162: /* Bug 9000052 - Used function remove_extra_spaces in package pay_au_tfn_magtape_flags for reporting name fields correctly */
163: CURSOR C_TFN_PAYER IS
164: SELECT
165: 'REPORT_START_DATE=P'
166: ,to_char(to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'ddmmyyyy')-14,'ddmmyyyy')/*Bug 2974527*/
167: ,'REPORT_END_DATE=P'
168: ,pay_magtape_generic.get_parameter_value('REPORT_END_DATE')
169: ,'PAYER_ABN=P'
170: ,hoi.org_information12

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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