DBA Data[Home] [Help]

APPS.IGS_GE_GEN_004 dependencies on FND_LOOKUPS

Line 249: FROM fnd_lookups

245: p_day_short_name IN VARCHAR2
246: ) RETURN VARCHAR2 IS
247: CURSOR cur_day (cp_day_short_name IN VARCHAR2) IS
248: SELECT meaning
249: FROM fnd_lookups
250: WHERE lookup_type = 'DAY_NAME'
251: AND lookup_code = cp_day_short_name;
252: l_day fnd_lookups.meaning%TYPE;
253: BEGIN

Line 252: l_day fnd_lookups.meaning%TYPE;

248: SELECT meaning
249: FROM fnd_lookups
250: WHERE lookup_type = 'DAY_NAME'
251: AND lookup_code = cp_day_short_name;
252: l_day fnd_lookups.meaning%TYPE;
253: BEGIN
254: OPEN cur_day (p_day_short_name);
255: FETCH cur_day INTO l_day;
256: CLOSE cur_day;