APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_LEVELS

Line 677: from msd_levels ml

673: p_level_id in number) is
674:
675: cursor c0 is
676: select dimension_code
677: from msd_levels ml
678: where level_id = p_level_id;
679:
680: cursor c1(p_hierarchy_id in number,
681: p_parent_level_id in number) is

Line 798: from msd_levels ml

794: p_level_id in number) is
795:
796: cursor c0 is
797: select dimension_code
798: from msd_levels ml
799: where level_id = p_level_id;
800:
801: cursor c1(p_hierarchy_id in number,
802: p_child_level_id in number) is

Line 1210: msd_levels ml

1206: mlv.system_attribute1,
1207: mlv.system_attribute2,
1208: mlv.dp_enabled_flag
1209: from msd_level_values mlv,
1210: msd_levels ml
1211: where ml.level_id = mlv.level_id
1212: and ml.dimension_code not in (C_PRD_DIM_CODE,C_ORG_DIM_CODE,C_REP_DIM_CODE,C_GEO_DIM_CODE)
1213: minus
1214: select p_demand_plan_id,

Line 1259: msd_levels ml

1255: mlv.system_attribute1,
1256: mlv.system_attribute2,
1257: mlv.dp_enabled_flag
1258: from msd_level_values mlv,
1259: msd_levels ml
1260: where ml.level_id = mlv.level_id
1261: and ml.dimension_code not in (C_PRD_DIM_CODE,C_ORG_DIM_CODE,C_GEO_DIM_CODE)
1262: minus
1263: select p_demand_plan_id,

Line 1308: msd_levels ml

1304: mlv.system_attribute1,
1305: mlv.system_attribute2,
1306: mlv.dp_enabled_flag
1307: from msd_level_values mlv,
1308: msd_levels ml
1309: where ml.level_id = mlv.level_id
1310: and ml.dimension_code not in (C_PRD_DIM_CODE,C_GEO_DIM_CODE,C_REP_DIM_CODE)
1311: minus
1312: select p_demand_plan_id,

Line 1357: msd_levels ml

1353: mlv.system_attribute1,
1354: mlv.system_attribute2,
1355: mlv.dp_enabled_flag
1356: from msd_level_values mlv,
1357: msd_levels ml
1358: where ml.level_id = mlv.level_id
1359: and ml.dimension_code not in (C_PRD_DIM_CODE,C_ORG_DIM_CODE)
1360: minus
1361: select p_demand_plan_id,

Line 1690: from msd_levels ml

1686: l_refresh_level_values varchar2(100) := C_FALSE;
1687:
1688: cursor c0(p_level_id in number) is
1689: select dimension_code
1690: from msd_levels ml
1691: where level_id = p_level_id;
1692:
1693: /* Bug# 4937978
1694: * The columns system_attribute1, system_attribute2 and dp_enabled_flag

Line 2419: from msd_levels ml

2415: x_refresh_num number;
2416:
2417: cursor c0(p_level_id in number) is
2418: select dimension_code
2419: from msd_levels ml
2420: where level_id = p_level_id;
2421:
2422: begin
2423:

Line 2480: from msd_levels ml

2476: l_refresh_level_values varchar2(100) := C_FALSE;
2477:
2478: cursor c0(p_level_id in number) is
2479: select dimension_code
2480: from msd_levels ml
2481: where level_id = p_level_id;
2482:
2483: /* Bug# 4937978
2484: * The columns system_attribute1, system_attribute2 and dp_enabled_flag

Line 3275: (select level_id from msd_levels where level_type_code = 1))

3271: mlv.system_attribute2,
3272: mlv.dp_enabled_flag
3273: from msd_level_values mlv
3274: where (mlv.level_id, mlv.sr_level_pk) IN (select level_id, sr_level_pk from msd_level_values where level_id in
3275: (select level_id from msd_levels where level_type_code = 1))
3276: minus
3277: select p_demand_plan_id,
3278: instance,
3279: level_id,