APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_LOOKUP_VALUES

Line 29: FROM igs_lookup_values

25: WHERE record_status = 'N';
26:
27: CURSOR chk_code_type_cur (p_code igs_uc_crfcode_ints.code%TYPE) IS
28: SELECT 'X'
29: FROM igs_lookup_values
30: WHERE lookup_type = 'IGS_UC_CODE_TYPES'
31: AND lookup_code = p_code
32: AND enabled_flag = 'Y'
33: AND NVL(closed_ind, 'N') = 'N';