DBA Data[Home] [Help]

APPS.FND_CONC_SSWA dependencies on FND_LOOKUP_VALUES_VL

Line 420: FROM fnd_lookup_values_vl

416: -- get values for weeks array from lookup FND_SCH_WEEKDAY_TYPE
417: rec_count := 1;
418: ltype := 'FND_SCH_WEEKDAY_TYPE';
419: FOR temp_record IN (SELECT meaning
420: FROM fnd_lookup_values_vl
421: WHERE lookup_type = ltype
422: ORDER BY to_number(lookup_code)) LOOP
423: weeks(rec_count) := temp_record.meaning;
424: rec_count := rec_count + 1;

Line 431: FROM fnd_lookup_values_vl

427: -- get values for weekdays array from lookup FND_SCH_WEEK_DAYS
428: rec_count := 1;
429: ltype := 'FND_SCH_WEEK_DAYS';
430: FOR temp_record IN (SELECT meaning
431: FROM fnd_lookup_values_vl
432: WHERE lookup_type = ltype
433: ORDER BY to_number(lookup_code)) LOOP
434: weekdays(rec_count) := temp_record.meaning;
435: rec_count := rec_count + 1;

Line 442: FROM fnd_lookup_values_vl

438: -- get values for months array from lookup FND_SCH_MONTHS
439: rec_count := 1;
440: ltype := 'FND_SCH_MONTHS';
441: FOR temp_record IN (SELECT meaning
442: FROM fnd_lookup_values_vl
443: WHERE lookup_type = ltype
444: ORDER BY to_number(lookup_code)) LOOP
445: months(rec_count) := temp_record.meaning;
446: rec_count := rec_count + 1;