APPS.IGS_EN_STDNT_PS_INTM_PKG dependencies on IGS_PE_HZ_PARTIES

Line 330: FROM hz_parties hp, igs_pe_hz_parties ihp

326: WHERE hp.party_id = NEW_REFERENCES.APPROVER_ID;
327:
328: CURSOR cur_exists_ioie IS
329: SELECT 'X'
330: FROM hz_parties hp, igs_pe_hz_parties ihp
331: WHERE hp.party_id = ihp.party_id and ihp.inst_org_ind = 'I' AND
332: ihp.oi_govt_institution_cd IS NOT NULL
333: AND IHP.OSS_ORG_UNIT_CD = NEW_REFERENCES.INSTITUTION_NAME
334: UNION ALL