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 FND_DATE

Line 97: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting

93: ** Cursor to retrieve the Supplier Detail information
94: */
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

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 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: