APPS.IGS_AV_VAL_ASU dependencies on IGS_LOOKUP_VALUES

Line 54: FROM igs_lookup_values lk

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
54: FROM igs_lookup_values lk
55: WHERE lk.lookup_type = 'OR_INSTITUTION_ADVSTEX'
56: AND lk.enabled_flag = 'Y'
57: AND lk.lookup_code = cp_exempt_inst;
58: BEGIN