APPS.IGS_EN_STDNT_PS_INTM_PKG dependencies on HZ_PARTIES

Line 325: FROM HZ_PARTIES hp

321: PROCEDURE Check_Parent_Existance AS
322:
323: CURSOR cur_rowid_HP IS
324: SELECT rowid
325: FROM HZ_PARTIES hp
326: WHERE hp.party_id = NEW_REFERENCES.APPROVER_ID;
327:
328: CURSOR cur_exists_ioie IS
329: SELECT 'X'

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