APPS.IGS_AV_VAL_ASU dependencies on IGS_PE_HZ_PARTIES

Line 49: FROM igs_pe_hz_parties ihp

45: CURSOR c_adv_stnd_exempt_inst_v (
46: cp_exempt_inst igs_av_adv_standing.exemption_institution_cd%TYPE
47: ) IS
48: SELECT ihp.oss_org_unit_cd exemption_institution_cd
49: FROM igs_pe_hz_parties ihp
50: WHERE ihp.inst_org_ind = 'I'
51: AND ihp.oss_org_unit_cd = cp_exempt_inst
52: UNION ALL
53: SELECT lk.lookup_code exemption_institution_cd