DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MED_EFILE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 140: from PER_ASSIGNMENT_EXTRA_INFO pae

136: -- Bug 7800013
137: aei_information13 source_code,
138: aei_information8 resident_reg_no,
139: aei_information9 disabled_or_aged
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