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_AU_TFN_MAGTAPE_FLAGS

Line 99: /* Bug 9000052 - Used function remove_extra_spaces in package pay_au_tfn_magtape_flags for reporting name fields correctly */

95:
96: /*Bug2920725 Corrected base tables to support security model*/
97: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
98: REPORT_END_DATE*/
99: /* Bug 9000052 - Used function remove_extra_spaces in package pay_au_tfn_magtape_flags for reporting name fields correctly */
100: CURSOR C_TFN_SUPPLIER IS
101: SELECT
102: 'LEGAL_EMPLOYER_NAME=P'
103: ,hou.name

Line 113: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(hoi.org_information3,inv_character_string,blank_character_string)) /Bug 9000052/

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*/
114: ,'CONTACT_NAME=P'
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

Line 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/

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*/
114: ,'CONTACT_NAME=P'
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'),' ')

Line 162: /* Bug 9000052 - Used function remove_extra_spaces in package pay_au_tfn_magtape_flags for reporting name fields correctly */

158: ** Cursor to retrieve the Payer(Employer) Detail information
159: */
160:
161: /*Bug2920725 Corrected base tables to support security model*/
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*/

Line 174: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(hoi.org_information3,' '),inv_character_string,blank_character_string)) /Bug 9000052/

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*/
173: ,'BUSINESS_NAME=P'
174: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(hoi.org_information3,' '),inv_character_string,blank_character_string)) /*Bug 9000052*/
175: ,'TRADING_NAME=P'
176: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(hoi.org_information4,' '),inv_character_string,blank_character_string)) /*Bug 9000052*/
177: ,'ADDRESS_LINE1=P'
178: ,translate(nvl(hlc.address_line_1,' '),inv_character_string,blank_character_string)

Line 176: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(hoi.org_information4,' '),inv_character_string,blank_character_string)) /Bug 9000052/

172: ,nvl(hoi.org_information13,'001') /* Bug#5570822 Setting Branch number to 001 to avoid ECI checker error*/
173: ,'BUSINESS_NAME=P'
174: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(hoi.org_information3,' '),inv_character_string,blank_character_string)) /*Bug 9000052*/
175: ,'TRADING_NAME=P'
176: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(hoi.org_information4,' '),inv_character_string,blank_character_string)) /*Bug 9000052*/
177: ,'ADDRESS_LINE1=P'
178: ,translate(nvl(hlc.address_line_1,' '),inv_character_string,blank_character_string)
179: ,'ADDRESS_LINE2=P'
180: ,translate(nvl(hlc.address_line_2,' '),inv_character_string,blank_character_string)

Line 190: ,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/

186: ,nvl(hlc.postal_code,' ')
187: ,'COUNTRY=P'
188: ,nvl(ftl.territory_short_name,' ')
189: ,'CONTACT_NAME=P'
190: ,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*/
191: ,'TELEPHONE_NUMBER=P'
192: ,hoi.org_information14
193: FROM hr_organization_information hoi
194: ,hr_locations_all hlc --Modified the table from hr_locations to hr_locations_all

Line 227: Bug 4066194 - Changed Package reference to "pay_au_tfn_magtape_flags"

223: -- restriction condition for the employees to print on magtape
224: -------------------------------------------------------------+
225: /*Bug2920725 Corrected base tables to support security model*/
226: /*
227: Bug 4066194 - Changed Package reference to "pay_au_tfn_magtape_flags"
228: Removed package self reference.
229:
230: Bug4247686 - Modified for performance reason
231: */

Line 233: /* Bug 9000052 - Used function remove_extra_spaces in package pay_au_tfn_magtape_flags for reporting name fields correctly */

229:
230: Bug4247686 - Modified for performance reason
231: */
232:
233: /* Bug 9000052 - Used function remove_extra_spaces in package pay_au_tfn_magtape_flags for reporting name fields correctly */
234: CURSOR C_TFN_PAYEE IS
235: SELECT
236: 'PAYEE_TFN=P'
237: ,replace(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FILE_NUMBER'),' ','')

Line 237: ,replace(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FILE_NUMBER'),' ','')

233: /* Bug 9000052 - Used function remove_extra_spaces in package pay_au_tfn_magtape_flags for reporting name fields correctly */
234: CURSOR C_TFN_PAYEE IS
235: SELECT
236: 'PAYEE_TFN=P'
237: ,replace(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FILE_NUMBER'),' ','')
238: ,'SURNAME=P'
239: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(pap.last_name,inv_character_string,blank_character_string)) /*Bug 9000052*/
240: ,'FIRST_GIVEN_NAME=P'
241: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.first_name,'NULL VALUE'),inv_character_string,blank_character_string)) /*Bug 9000052*/

Line 239: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(pap.last_name,inv_character_string,blank_character_string)) /Bug 9000052/

235: SELECT
236: 'PAYEE_TFN=P'
237: ,replace(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FILE_NUMBER'),' ','')
238: ,'SURNAME=P'
239: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(pap.last_name,inv_character_string,blank_character_string)) /*Bug 9000052*/
240: ,'FIRST_GIVEN_NAME=P'
241: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.first_name,'NULL VALUE'),inv_character_string,blank_character_string)) /*Bug 9000052*/
242: ,'SECOND_GIVEN_NAME=P'
243: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.middle_names,' '),inv_character_string,blank_character_string)) /*Bug 9000052*/

Line 241: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.first_name,'NULL VALUE'),inv_character_string,blank_character_string)) /Bug 9000052/

237: ,replace(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FILE_NUMBER'),' ','')
238: ,'SURNAME=P'
239: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(pap.last_name,inv_character_string,blank_character_string)) /*Bug 9000052*/
240: ,'FIRST_GIVEN_NAME=P'
241: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.first_name,'NULL VALUE'),inv_character_string,blank_character_string)) /*Bug 9000052*/
242: ,'SECOND_GIVEN_NAME=P'
243: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.middle_names,' '),inv_character_string,blank_character_string)) /*Bug 9000052*/
244: ,'EMPLOYEE_NUMBER=P'
245: ,nvl(pap.employee_number,' ')

Line 243: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.middle_names,' '),inv_character_string,blank_character_string)) /Bug 9000052/

239: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(pap.last_name,inv_character_string,blank_character_string)) /*Bug 9000052*/
240: ,'FIRST_GIVEN_NAME=P'
241: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.first_name,'NULL VALUE'),inv_character_string,blank_character_string)) /*Bug 9000052*/
242: ,'SECOND_GIVEN_NAME=P'
243: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.middle_names,' '),inv_character_string,blank_character_string)) /*Bug 9000052*/
244: ,'EMPLOYEE_NUMBER=P'
245: ,nvl(pap.employee_number,' ')
246: ,'PREVIOUS_SURNAME=P'
247: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.previous_last_name,' '),inv_character_string,blank_character_string)) /*Bug 9000052*/

Line 247: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.previous_last_name,' '),inv_character_string,blank_character_string)) /Bug 9000052/

243: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.middle_names,' '),inv_character_string,blank_character_string)) /*Bug 9000052*/
244: ,'EMPLOYEE_NUMBER=P'
245: ,nvl(pap.employee_number,' ')
246: ,'PREVIOUS_SURNAME=P'
247: ,pay_au_tfn_magtape_flags.remove_extra_spaces(translate(nvl(pap.previous_last_name,' '),inv_character_string,blank_character_string)) /*Bug 9000052*/
248: ,'DATE_OF_BIRTH=P'
249: ,to_char(pap.date_of_birth,'DDMMYYYY')
250: ,'ADDRESS_LINE1=P'
251: ,translate(nvl(pad.address_line1,' '),inv_character_string,blank_character_string)

Line 265: ,decode(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'CURRENT_OR_TERMINATED'),'T','T',' ')

261: ,nvl(decode(pad.country,'AU',' ',pad.country),' ')
262: ,'PAYROLL_NUMBER=P'
263: ,paa.assignment_number
264: ,'PAYEE_TERMINATOR_IND=P'
265: ,decode(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'CURRENT_OR_TERMINATED'),'T','T',' ')
266: ,'AU_RES=P'
267: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'AUSTRALIAN_RESIDENT_FLAG'),' ')
268: ,'BASIS_OF_PAYMENT=P'
269: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')

Line 267: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'AUSTRALIAN_RESIDENT_FLAG'),' ')

263: ,paa.assignment_number
264: ,'PAYEE_TERMINATOR_IND=P'
265: ,decode(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'CURRENT_OR_TERMINATED'),'T','T',' ')
266: ,'AU_RES=P'
267: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'AUSTRALIAN_RESIDENT_FLAG'),' ')
268: ,'BASIS_OF_PAYMENT=P'
269: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')
270: ,'TAX_FREE_TH=P'
271: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FREE_THRESHOLD_FLAG'),' ')

Line 269: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')

265: ,decode(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'CURRENT_OR_TERMINATED'),'T','T',' ')
266: ,'AU_RES=P'
267: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'AUSTRALIAN_RESIDENT_FLAG'),' ')
268: ,'BASIS_OF_PAYMENT=P'
269: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')
270: ,'TAX_FREE_TH=P'
271: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FREE_THRESHOLD_FLAG'),' ')
272: ,'FTB=P'
273: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'FTA_CLAIM_FLAG'),'N')

Line 271: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FREE_THRESHOLD_FLAG'),' ')

267: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'AUSTRALIAN_RESIDENT_FLAG'),' ')
268: ,'BASIS_OF_PAYMENT=P'
269: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')
270: ,'TAX_FREE_TH=P'
271: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FREE_THRESHOLD_FLAG'),' ')
272: ,'FTB=P'
273: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'FTA_CLAIM_FLAG'),'N')
274: ,'REBATE_FLAG=P'
275: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'REBATE_FLAG'),'N')

Line 273: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'FTA_CLAIM_FLAG'),'N')

269: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')
270: ,'TAX_FREE_TH=P'
271: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FREE_THRESHOLD_FLAG'),' ')
272: ,'FTB=P'
273: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'FTA_CLAIM_FLAG'),'N')
274: ,'REBATE_FLAG=P'
275: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'REBATE_FLAG'),'N')
276: ,'HECS=P'
277: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'HECS_FLAG'),' ')

Line 275: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'REBATE_FLAG'),'N')

271: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FREE_THRESHOLD_FLAG'),' ')
272: ,'FTB=P'
273: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'FTA_CLAIM_FLAG'),'N')
274: ,'REBATE_FLAG=P'
275: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'REBATE_FLAG'),'N')
276: ,'HECS=P'
277: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'HECS_FLAG'),' ')
278: ,'SFSS=P'
279: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SFSS_FLAG'),'N')

Line 277: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'HECS_FLAG'),' ')

273: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'FTA_CLAIM_FLAG'),'N')
274: ,'REBATE_FLAG=P'
275: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'REBATE_FLAG'),'N')
276: ,'HECS=P'
277: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'HECS_FLAG'),' ')
278: ,'SFSS=P'
279: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SFSS_FLAG'),'N')
280: ,'TFN_FOR_SUPER=P'
281: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TFN_FOR_SUPER'),'N')

Line 279: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SFSS_FLAG'),'N')

275: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'REBATE_FLAG'),'N')
276: ,'HECS=P'
277: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'HECS_FLAG'),' ')
278: ,'SFSS=P'
279: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SFSS_FLAG'),'N')
280: ,'TFN_FOR_SUPER=P'
281: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TFN_FOR_SUPER'),'N')
282: ,'DATE_DECLARATION=P'
283: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'DECLARATION_SIGNED_DATE'),'00000000')

Line 281: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TFN_FOR_SUPER'),'N')

277: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'HECS_FLAG'),' ')
278: ,'SFSS=P'
279: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SFSS_FLAG'),'N')
280: ,'TFN_FOR_SUPER=P'
281: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TFN_FOR_SUPER'),'N')
282: ,'DATE_DECLARATION=P'
283: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'DECLARATION_SIGNED_DATE'),'00000000')
284: ,'EFFECTIVE_START_DATE=P'
285: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'EFFECTIVE_START_DATE')

Line 283: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'DECLARATION_SIGNED_DATE'),'00000000')

279: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SFSS_FLAG'),'N')
280: ,'TFN_FOR_SUPER=P'
281: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TFN_FOR_SUPER'),'N')
282: ,'DATE_DECLARATION=P'
283: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'DECLARATION_SIGNED_DATE'),'00000000')
284: ,'EFFECTIVE_START_DATE=P'
285: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'EFFECTIVE_START_DATE')
286: ,'SATO=P' /*bug7270073*/
287: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SENIOR_FLAG'),'N')

Line 285: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'EFFECTIVE_START_DATE')

281: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TFN_FOR_SUPER'),'N')
282: ,'DATE_DECLARATION=P'
283: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'DECLARATION_SIGNED_DATE'),'00000000')
284: ,'EFFECTIVE_START_DATE=P'
285: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'EFFECTIVE_START_DATE')
286: ,'SATO=P' /*bug7270073*/
287: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SENIOR_FLAG'),'N')
288: FROM
289: hr_soft_coding_keyflex hsc

Line 287: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SENIOR_FLAG'),'N')

283: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'DECLARATION_SIGNED_DATE'),'00000000')
284: ,'EFFECTIVE_START_DATE=P'
285: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'EFFECTIVE_START_DATE')
286: ,'SATO=P' /*bug7270073*/
287: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SENIOR_FLAG'),'N')
288: FROM
289: hr_soft_coding_keyflex hsc
290: ,per_assignments_f paa
291: ,per_people_f pap