APPS.IGS_AV_VAL_AS dependencies on IGS_LOOKUP_VALUES

Line 72: FROM igs_lookup_values lk

68: AND ihp.oi_govt_institution_cd IS NOT NULL
69: AND ihp.oss_org_unit_cd = cp_exempt_inst
70: UNION ALL
71: SELECT lk.lookup_code exemption_institution_cd
72: FROM igs_lookup_values lk
73: WHERE lk.lookup_type = 'OR_INST_EXEMPTIONS'
74: AND lk.enabled_flag = 'Y'
75: AND lk.lookup_code = cp_exempt_inst;
76: BEGIN