APPS.IGS_AV_GEN_001 dependencies on IGS_LOOKUP_VALUES

Line 498: FROM igs_lookup_values lk

494: AND ihp.oi_govt_institution_cd IS NOT NULL
495: AND ihp.oss_org_unit_cd = cp_exemption_institution_cd
496: UNION ALL
497: SELECT 'x'
498: FROM igs_lookup_values lk
499: WHERE lk.lookup_type = 'OR_INST_EXEMPTIONS'
500: AND lk.enabled_flag = 'Y'
501: AND lk.lookup_code = cp_exemption_institution_cd;
502: CURSOR c_institution (