APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on FND_DATE

Line 130: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy')

126: per_assignment_extra_info pae
127: where
128: pae.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGN_ID')
129: and pae.information_type = 'KR_YEA_DETAIL_DONATION_INFO'
130: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy')
131: = g_target_year
132: group by
133: pae.assignment_id,
134: aei_information7,