DBA Data[Home] [Help]

APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on PER_KR_RESIDENT_REG_NUMBER_V

Line 205: per_kr_resident_reg_number_v resreg,

201: 'NUM_OF_DONATIONS=P', sum(nvl(pae.aei_information4, 1)),
202: 'DONATION_AMOUNT=P', sum(pae.aei_information3)
203: from per_people_f pp,
204: per_assignments_f pa,
205: per_kr_resident_reg_number_v resreg,
206: per_assignment_extra_info pae
207: where pa.assignment_id = p_asg_id
208: and fnd_date.canonical_to_date(pae.aei_information1)
209: between pa.effective_start_date and pa.effective_end_date