APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_OR_INST_EXEMPT_V

Line 1195: CURSOR c_exists (cp_exemption_institution_cd igs_or_inst_exempt_v.exemption_institution_cd%TYPE) IS

1191: /*
1192: check whether exemtion_inst_cd is valid or not
1193: */
1194: DECLARE
1195: CURSOR c_exists (cp_exemption_institution_cd igs_or_inst_exempt_v.exemption_institution_cd%TYPE) IS
1196: SELECT 'x'
1197: FROM hz_parties hp, igs_pe_hz_parties ihp
1198: WHERE hp.party_id = ihp.party_id
1199: AND ihp.inst_org_ind = 'I'