APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_CS_DEFINITIONS

Line 397: from msd_cs_definitions

393: CURSOR get_refresh_num(p_name in varchar2, p_desig in varchar2) IS
394: select last_refresh_num
395: from msd_cs_data_headers
396: where cs_definition_id = (select cs_definition_id
397: from msd_cs_definitions
398: where name = p_name)
399: and cs_name = nvl(p_desig, cs_name)
400: order by last_refresh_num desc;
401:

Line 1503: from msd_cs_definitions

1499: cursor c1(p_cs_defn_name in varchar2) is
1500: select cs_definition_id,
1501: multiple_stream_flag,
1502: stripe_flag
1503: from msd_cs_definitions
1504: where name = p_cs_defn_name;
1505:
1506: cursor c2(p_cs_id in number) is
1507: select dimension_code

Line 2128: from msd_cs_definitions

2124: if (c1_rec.parameter_name is not null) then
2125:
2126: delete from msd_cs_data_ds
2127: where cs_definition_id = (select cs_definition_id
2128: from msd_cs_definitions
2129: where name = c1_rec.parameter_type)
2130: and cs_name = c1_rec.parameter_name
2131: and demand_plan_id = p_demand_plan_id;
2132:

Line 2137: from msd_cs_definitions

2133: else
2134:
2135: delete from msd_cs_data_ds
2136: where cs_definition_id = (select cs_definition_id
2137: from msd_cs_definitions
2138: where name = c1_rec.parameter_type)
2139: and demand_plan_id = p_demand_plan_id;
2140:
2141: end if;

Line 2203: msd_cs_definitions csd

2199: sysdate,
2200: fnd_global.user_id
2201: from msd_dp_parameters mdp,
2202: msd_cs_data_headers csh,
2203: msd_cs_definitions csd
2204: where mdp.parameter_type = csd.name
2205: and csd.cs_definition_id = csh.cs_definition_id
2206: and csh.cs_name = nvl(mdp.parameter_name, csh.cs_name)
2207: and mdp.demand_plan_id = p_demand_plan_id

Line 2669: from msd_cs_definitions mcd

2665: mcd.name,
2666: mcd.multiple_stream_flag,
2667: mcd.stripe_flag,
2668: nvl(mcd.planning_server_view_name, 'MSD_CS_DATA_V')
2669: from msd_cs_definitions mcd
2670: where name = p_name;
2671:
2672: cursor get_dim_col_id (p_cs_id in number) is
2673: SELECT collect_level_id

Line 2893: from msd_cs_definitions mcd

2889: mcd.name,
2890: mcd.multiple_stream_flag,
2891: mcd.stripe_flag,
2892: nvl(mcd.planning_server_view_name,'MSD_CS_DATA_V')
2893: from msd_cs_definitions mcd
2894: where name = p_name;
2895:
2896: cursor get_dim_col_id (p_cs_id in number) is
2897: SELECT collect_level_id