DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MED_EFILE_PKG dependencies on FND_DATE

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

133: from PER_ASSIGNMENT_EXTRA_INFO pae
134: where
135: pae.assignment_id =pay_magtape_generic.get_parameter_value('ASSIGN_ID')
136: and pae.information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
137: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year
138: group by pae.assignment_id, aei_information8,aei_information5,aei_information6,
139: aei_information7,aei_information8 ,aei_information9
140: );
141: