DBA Data[Home] [Help]

APPS.FND_CONC_SSWA dependencies on FND_LOOKUP_VALUES_VL

Line 481: FROM fnd_lookup_values_vl

477: -- get values for weeks array from lookup FND_SCH_WEEKDAY_TYPE
478: rec_count := 1;
479: ltype := 'FND_SCH_WEEKDAY_TYPE';
480: FOR temp_record IN (SELECT meaning
481: FROM fnd_lookup_values_vl
482: WHERE lookup_type = ltype
483: ORDER BY to_number(lookup_code)) LOOP
484: weeks(rec_count) := temp_record.meaning;
485: rec_count := rec_count + 1;

Line 492: FROM fnd_lookup_values_vl

488: -- get values for weekdays array from lookup FND_SCH_WEEK_DAYS
489: rec_count := 1;
490: ltype := 'FND_SCH_WEEK_DAYS';
491: FOR temp_record IN (SELECT meaning
492: FROM fnd_lookup_values_vl
493: WHERE lookup_type = ltype
494: ORDER BY to_number(lookup_code)) LOOP
495: weekdays(rec_count) := temp_record.meaning;
496: rec_count := rec_count + 1;

Line 503: FROM fnd_lookup_values_vl

499: -- get values for months array from lookup FND_SCH_MONTHS
500: rec_count := 1;
501: ltype := 'FND_SCH_MONTHS';
502: FOR temp_record IN (SELECT meaning
503: FROM fnd_lookup_values_vl
504: WHERE lookup_type = ltype
505: ORDER BY to_number(lookup_code)) LOOP
506: months(rec_count) := temp_record.meaning;
507: rec_count := rec_count + 1;