DBA Data[Home] [Help]

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on FND_LOOKUP_VALUES_VL

Line 477: from fnd_lookup_values_vl

473:
474: -- Get Invalid Time Hierarchy Params
475: CURSOR get_inv_hier_tim_prms (p_demand_plan_id IN NUMBER, p_lvl_id in NUMBER) IS
476: select meaning
477: from fnd_lookup_values_vl
478: where lookup_type = 'MSD_PERIOD_TYPE'
479: and lookup_code = p_lvl_id
480: and not exists (
481: select 1

Line 2716: from fnd_lookup_values_vl

2712: from dual;
2713:
2714: CURSOR get_meaning_1 (p_lookup_type in varchar2, p_lookup_code in varchar2) IS
2715: select meaning
2716: from fnd_lookup_values_vl
2717: where lookup_type = p_lookup_type
2718: and lookup_code = p_lookup_code;
2719:
2720: CURSOR get_meaning_2 (p_lookup_type in varchar2, p_lookup_code in number) IS

Line 2722: from fnd_lookup_values_vl

2718: and lookup_code = p_lookup_code;
2719:
2720: CURSOR get_meaning_2 (p_lookup_type in varchar2, p_lookup_code in number) IS
2721: select meaning
2722: from fnd_lookup_values_vl
2723: where lookup_type = p_lookup_type
2724: and lookup_code = to_char(p_lookup_code);
2725:
2726: begin