DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_LEVELS

Line 503: from msd_levels

499:
500: /* Get the Parent Level Type */
501: begin
502: select level_type_code into v_parent_lvl_type
503: from msd_levels
504: where level_id = p_parent_level_id
505: and plan_type is null; --vinekuma
506: exception
507: when NO_DATA_FOUND then

Line 559: from msd_levels

555:
556:
557: select level_type_code, dimension_code, org_relationship_view
558: into v_lvl_type, v_dim_code, v_org_view
559: from msd_levels
560: where level_id = p_level_id
561: and plan_type is null; --vinekuma
562:
563: IF ((p_update_lvl_table = 1 and MSD_COMMON_UTILITIES.COLLECT_ILP = 2) or MSD_COMMON_UTILITIES.COLLECT_ILP = 3) THEN /* IF 1 */