DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MED_EFILE_PKG dependencies on FND_DATE

Line 144: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year

140: from PER_ASSIGNMENT_EXTRA_INFO pae
141: where
142: pae.assignment_id =pay_magtape_generic.get_parameter_value('ASSIGN_ID')
143: and pae.information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
144: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year
145: group by pae.assignment_id, aei_information8,aei_information5,aei_information6,aei_information13,
146: aei_information7,aei_information8 ,aei_information9
147: );
148: