APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on FND_DATE

Line 84: , to_char(fnd_date.canonical_to_date(eev6.SCREEN_ENTRY_VALUE),'ddmmyyyy')

80: 'YC','C',
81: 'X')
82: , decode(eev5.SCREEN_ENTRY_VALUE,'Y','Y','N','N','YY','Y','NY','N',Null) hecs_flag
83: , decode(eev5.SCREEN_ENTRY_VALUE,'YY','Y','NY','Y','N') SFSS_ENTRY_VALUE
84: , to_char(fnd_date.canonical_to_date(eev6.SCREEN_ENTRY_VALUE),'ddmmyyyy')
85: , decode(decode(eev8.SCREEN_ENTRY_VALUE,'Y','Y','N','N','YY','Y','NY','N','N'),'Y','Y',decode(eev4.SCREEN_ENTRY_VALUE,'Y','Y','N'))
86: , eev13.SCREEN_ENTRY_VALUE
87: , pee.effective_start_date
88: , decode(sign(nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) - c_report_end_date),

Line 134: (trunc(fnd_date.canonical_to_date(pee.entry_information1)) BETWEEN c_report_end_date - 13 AND c_report_end_date

130: where pps1.person_id=pps.person_id
131: AND pps1.date_start <= c_report_end_date
132: ) /*Bug2751008*/
133: AND ( pee.entry_information_category = 'AU_TAX DEDUCTIONS' and
134: (trunc(fnd_date.canonical_to_date(pee.entry_information1)) BETWEEN c_report_end_date - 13 AND c_report_end_date
135: OR nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) BETWEEN c_report_end_date - 13 AND c_report_end_date
136: )
137: ) /* Bug#5864230 */
138: AND paa.effective_start_date = (SELECT max(effective_start_date)