APPS.IGS_AV_VAL_AS dependencies on IGS_PE_HZ_PARTIES

Line 66: FROM igs_pe_hz_parties ihp

62: DECLARE
63: CURSOR c_exempt_inst_v(
64: cp_exempt_inst IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE) IS
65: SELECT ihp.oss_org_unit_cd exemption_institution_cd
66: FROM igs_pe_hz_parties ihp
67: where ihp.inst_org_ind = 'I'
68: AND ihp.oi_govt_institution_cd IS NOT NULL
69: AND ihp.oss_org_unit_cd = cp_exempt_inst
70: UNION ALL