DBA Data[Home] [Help]

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on FND_LOOKUP_VALUES_VL

Line 473: from fnd_lookup_values_vl

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

Line 2583: from fnd_lookup_values_vl

2579: from dual;
2580:
2581: CURSOR get_meaning_1 (p_lookup_type in varchar2, p_lookup_code in varchar2) IS
2582: select meaning
2583: from fnd_lookup_values_vl
2584: where lookup_type = p_lookup_type
2585: and lookup_code = p_lookup_code;
2586:
2587: CURSOR get_meaning_2 (p_lookup_type in varchar2, p_lookup_code in number) IS

Line 2589: from fnd_lookup_values_vl

2585: and lookup_code = p_lookup_code;
2586:
2587: CURSOR get_meaning_2 (p_lookup_type in varchar2, p_lookup_code in number) IS
2588: select meaning
2589: from fnd_lookup_values_vl
2590: where lookup_type = p_lookup_type
2591: and lookup_code = to_char(p_lookup_code);
2592:
2593: begin