APPS.IGS_AD_GEN_007 dependencies on HZ_PERSON_INTEREST

Line 238: FROM HZ_PERSON_INTEREST PI, IGS_AD_HZ_EXTRACURR_ACT HEA

234: WHERE person_id = p_person_id;
235:
236: CURSOR c_ex IS
237: SELECT PI.PARTY_ID
238: FROM HZ_PERSON_INTEREST PI, IGS_AD_HZ_EXTRACURR_ACT HEA
239: WHERE PI.PERSON_INTEREST_ID = HEA.PERSON_INTEREST_ID
240: AND PI.PARTY_ID = p_person_id;
241:
242: