DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MED_EFILE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 133: from PER_ASSIGNMENT_EXTRA_INFO pae

129: sum(nvl(aei_information3,0)) cash_expense_amount,
130: aei_information7 relarionship,
131: aei_information8 resident_reg_no,
132: aei_information9 disabled_or_aged
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