APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_LOOKUP_VALUES

Line 116: FROM igs_lookup_values

112:
113: CURSOR c_meaning (cp_c_lookup_type IN VARCHAR2,
114: cp_c_lookup_code IN VARCHAR2) IS
115: SELECT meaning
116: FROM igs_lookup_values
117: WHERE lookup_type = cp_c_lookup_type
118: AND lookup_code = cp_c_lookup_code
119: AND enabled_flag = 'Y'
120: AND NVL(closed_ind,'N') = 'N'

Line 123: l_c_meaning igs_lookup_values.meaning%TYPE;

119: AND enabled_flag = 'Y'
120: AND NVL(closed_ind,'N') = 'N'
121: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE);
122:
123: l_c_meaning igs_lookup_values.meaning%TYPE;
124:
125: BEGIN
126: OPEN c_meaning(p_c_lookup_type,p_c_lookup_code) ;
127: FETCH c_meaning INTO l_c_meaning;