APPS.IGS_EN_STDNT_PS_INTM_PKG dependencies on IGS_LOOKUP_VALUES

Line 336: FROM igs_lookup_values lk

332: ihp.oi_govt_institution_cd IS NOT NULL
333: AND IHP.OSS_ORG_UNIT_CD = NEW_REFERENCES.INSTITUTION_NAME
334: UNION ALL
335: SELECT 'X'
336: FROM igs_lookup_values lk
337: WHERE lk.lookup_type = 'OR_INST_EXEMPTIONS' AND
338: lk.enabled_flag = 'Y' AND
339: lookup_code = NEW_REFERENCES.INSTITUTION_NAME ;
340: