APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_HIERARCHIES

Line 689: from msd_hierarchies

685: and mhl.parent_level_id = p_parent_level_id;
686:
687: cursor c2 (p_dimension_code in varchar2) is
688: select hierarchy_id
689: from msd_hierarchies
690: where dimension_code = p_dimension_code;
691:
692: x_current_parent_level_id number;
693: x_child_level number;

Line 810: from msd_hierarchies

806: and mhl.level_id = p_child_level_id;
807:
808: cursor c2 (p_dimension_code in varchar2) is
809: select hierarchy_id
810: from msd_hierarchies
811: where dimension_code = p_dimension_code;
812:
813: x_current_child_level_id number;
814: x_parent_level number;