APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_LEVELS

Line 680: from msd_levels ml

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

Line 801: from msd_levels ml

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

Line 1216: msd_levels ml

1212: mlv.system_attribute1,
1213: mlv.system_attribute2,
1214: mlv.dp_enabled_flag
1215: from msd_level_values mlv,
1216: msd_levels ml
1217: where ml.level_id = mlv.level_id
1218: and ml.dimension_code not in (C_PRD_DIM_CODE,C_ORG_DIM_CODE,C_REP_DIM_CODE,C_GEO_DIM_CODE)
1219: minus
1220: select p_demand_plan_id,

Line 1265: msd_levels ml

1261: mlv.system_attribute1,
1262: mlv.system_attribute2,
1263: mlv.dp_enabled_flag
1264: from msd_level_values mlv,
1265: msd_levels ml
1266: where ml.level_id = mlv.level_id
1267: and ml.dimension_code not in (C_PRD_DIM_CODE,C_ORG_DIM_CODE,C_GEO_DIM_CODE)
1268: minus
1269: select p_demand_plan_id,

Line 1314: msd_levels ml

1310: mlv.system_attribute1,
1311: mlv.system_attribute2,
1312: mlv.dp_enabled_flag
1313: from msd_level_values mlv,
1314: msd_levels ml
1315: where ml.level_id = mlv.level_id
1316: and ml.dimension_code not in (C_PRD_DIM_CODE,C_GEO_DIM_CODE,C_REP_DIM_CODE)
1317: minus
1318: select p_demand_plan_id,

Line 1363: msd_levels ml

1359: mlv.system_attribute1,
1360: mlv.system_attribute2,
1361: mlv.dp_enabled_flag
1362: from msd_level_values mlv,
1363: msd_levels ml
1364: where ml.level_id = mlv.level_id
1365: and ml.dimension_code not in (C_PRD_DIM_CODE,C_ORG_DIM_CODE)
1366: minus
1367: select p_demand_plan_id,

Line 1696: from msd_levels ml

1692: l_refresh_level_values varchar2(100) := C_FALSE;
1693:
1694: cursor c0(p_level_id in number) is
1695: select dimension_code
1696: from msd_levels ml
1697: where level_id = p_level_id;
1698:
1699: /* Bug# 4937978
1700: * The columns system_attribute1, system_attribute2 and dp_enabled_flag

Line 2425: from msd_levels ml

2421: x_refresh_num number;
2422:
2423: cursor c0(p_level_id in number) is
2424: select dimension_code
2425: from msd_levels ml
2426: where level_id = p_level_id;
2427:
2428: begin
2429:

Line 2486: from msd_levels ml

2482: l_refresh_level_values varchar2(100) := C_FALSE;
2483:
2484: cursor c0(p_level_id in number) is
2485: select dimension_code
2486: from msd_levels ml
2487: where level_id = p_level_id;
2488:
2489: /* Bug# 4937978
2490: * The columns system_attribute1, system_attribute2 and dp_enabled_flag

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

3277: mlv.system_attribute2,
3278: mlv.dp_enabled_flag
3279: from msd_level_values mlv
3280: where (mlv.level_id, mlv.sr_level_pk) IN (select level_id, sr_level_pk from msd_level_values where level_id in
3281: (select level_id from msd_levels where level_type_code = 1))
3282: minus
3283: select p_demand_plan_id,
3284: instance,
3285: level_id,