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 231: Bug 4066194 - Changed Package reference to "pay_au_tfn_magtape_flags"

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

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

237:
238: CURSOR C_TFN_PAYEE IS
239: SELECT
240: 'PAYEE_TFN=P'
241: ,replace(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FILE_NUMBER'),' ','')
242: ,'SURNAME=P'
243: ,translate(pap.last_name,inv_character_string,blank_character_string)
244: ,'FIRST_GIVEN_NAME=P'
245: ,translate(nvl(pap.first_name,'NULL VALUE'),inv_character_string,blank_character_string)

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

265: ,nvl(decode(pad.country,'AU',' ',pad.country),' ')
266: ,'PAYROLL_NUMBER=P'
267: ,paa.assignment_number
268: ,'PAYEE_TERMINATOR_IND=P'
269: ,decode(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'CURRENT_OR_TERMINATED'),'T','T',' ')
270: ,'AU_RES=P'
271: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'AUSTRALIAN_RESIDENT_FLAG'),' ')
272: ,'BASIS_OF_PAYMENT=P'
273: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')

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

267: ,paa.assignment_number
268: ,'PAYEE_TERMINATOR_IND=P'
269: ,decode(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'CURRENT_OR_TERMINATED'),'T','T',' ')
270: ,'AU_RES=P'
271: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'AUSTRALIAN_RESIDENT_FLAG'),' ')
272: ,'BASIS_OF_PAYMENT=P'
273: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')
274: ,'TAX_FREE_TH=P'
275: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FREE_THRESHOLD_FLAG'),' ')

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

269: ,decode(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'CURRENT_OR_TERMINATED'),'T','T',' ')
270: ,'AU_RES=P'
271: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'AUSTRALIAN_RESIDENT_FLAG'),' ')
272: ,'BASIS_OF_PAYMENT=P'
273: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')
274: ,'TAX_FREE_TH=P'
275: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FREE_THRESHOLD_FLAG'),' ')
276: ,'FTB=P'
277: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'FTA_CLAIM_FLAG'),'N')

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

271: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'AUSTRALIAN_RESIDENT_FLAG'),' ')
272: ,'BASIS_OF_PAYMENT=P'
273: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')
274: ,'TAX_FREE_TH=P'
275: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FREE_THRESHOLD_FLAG'),' ')
276: ,'FTB=P'
277: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'FTA_CLAIM_FLAG'),'N')
278: ,'REBATE_FLAG=P'
279: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'REBATE_FLAG'),'N')

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

273: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'BASIS_OF_PAYMENT')
274: ,'TAX_FREE_TH=P'
275: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TAX_FREE_THRESHOLD_FLAG'),' ')
276: ,'FTB=P'
277: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'FTA_CLAIM_FLAG'),'N')
278: ,'REBATE_FLAG=P'
279: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'REBATE_FLAG'),'N')
280: ,'HECS=P'
281: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'HECS_FLAG'),' ')

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

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

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

277: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'FTA_CLAIM_FLAG'),'N')
278: ,'REBATE_FLAG=P'
279: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'REBATE_FLAG'),'N')
280: ,'HECS=P'
281: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'HECS_FLAG'),' ')
282: ,'SFSS=P'
283: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SFSS_FLAG'),'N')
284: ,'TFN_FOR_SUPER=P'
285: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TFN_FOR_SUPER'),'N')

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

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

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

281: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'HECS_FLAG'),' ')
282: ,'SFSS=P'
283: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SFSS_FLAG'),'N')
284: ,'TFN_FOR_SUPER=P'
285: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TFN_FOR_SUPER'),'N')
286: ,'DATE_DECLARATION=P'
287: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'DECLARATION_SIGNED_DATE'),'00000000')
288: ,'EFFECTIVE_START_DATE=P'
289: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'EFFECTIVE_START_DATE')

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

283: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SFSS_FLAG'),'N')
284: ,'TFN_FOR_SUPER=P'
285: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'TFN_FOR_SUPER'),'N')
286: ,'DATE_DECLARATION=P'
287: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'DECLARATION_SIGNED_DATE'),'00000000')
288: ,'EFFECTIVE_START_DATE=P'
289: ,pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'EFFECTIVE_START_DATE')
290: ,'SATO=P' /*bug7270073*/
291: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SENIOR_FLAG'),'N')

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

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

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

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