APPS.IGS_UC_START_NEW_CYCLE dependencies on IGS_LOOKUP_VALUES

Line 50: FROM igs_lookup_values

46:
47: -- Cursor to obtain the Supported Cycle - 1
48: CURSOR cur_sup_cycle IS
49: SELECT MAX(TO_NUMBER(lookup_code)) - 1
50: FROM igs_lookup_values
51: WHERE lookup_type = 'IGS_UC_SUP_CYCLE'
52: AND enabled_flag = 'Y'
53: AND NVL(closed_Ind, 'N') = 'N';
54:

Line 58: FROM igs_lookup_values

54:
55: -- Cursor to obtain the Next Cycle i.e. Supported Cycle + 1
56: CURSOR cur_next_cycle (p_current_cycle igs_uc_defaults.current_cycle%TYPE) IS
57: SELECT TO_NUMBER(lookup_code)
58: FROM igs_lookup_values
59: WHERE lookup_type = 'IGS_UC_SUP_CYCLE'
60: AND TO_NUMBER(lookup_code) = p_current_cycle + 1
61: AND enabled_flag = 'Y'
62: AND NVL(closed_Ind, 'N') = 'N';