APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on PER_PEOPLE_F

Line 176: from per_people_f pp,

172: 'AMT_SUBJ_TO_EXEM=P', pae.aei_information10,
173: 'EXEM_FOR_TARGET_YR=P', pae.aei_information4,
174: 'OBSOLETE_AMOUNT=P', pae.aei_information11,
175: 'CARRY_OVER_AMT=P', pae.aei_information5
176: from per_people_f pp,
177: per_assignments_f pa,
178: per_assignment_extra_info pae
179: where pa.assignment_id = p_asg_id
180: and pp.person_id = pa.person_id

Line 203: from per_people_f pp,

199: 'DONATOR_NAME=P', pp.last_name || pp.first_name,
200: 'DONATOR_REG_NUM=P', pae.aei_information13,
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