APPS.PAY_AU_TFN_MAGTAPE dependencies on FND_DATE

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

97: ** Cursor to retrieve the Supplier Detail information
98: */
99:
100: /*Bug2920725 Corrected base tables to support security model*/
101: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
102: REPORT_END_DATE*/
103:
104: CURSOR C_TFN_SUPPLIER IS
105: SELECT

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