DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_LEVELS

Line 487: from msd_levels

483:
484: /* Get the Parent Level Type */
485: begin
486: select level_type_code into v_parent_lvl_type
487: from msd_levels
488: where level_id = p_parent_level_id
489: and plan_type is null; --vinekuma
490: exception
491: when NO_DATA_FOUND then

Line 533: from msd_levels

529: IF (p_update_lvl_table = 1) THEN /* IF 1 */
530:
531: select level_type_code, dimension_code, org_relationship_view
532: into v_lvl_type, v_dim_code, v_org_view
533: from msd_levels
534: where level_id = p_level_id
535: and plan_type is null; --vinekuma
536:
537: IF (p_level_id = 1 OR p_level_id = 3) THEN /* IF 2 */