APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_CS_DEFINITIONS

Line 400: from msd_cs_definitions

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

Line 1509: from msd_cs_definitions

1505: cursor c1(p_cs_defn_name in varchar2) is
1506: select cs_definition_id,
1507: multiple_stream_flag,
1508: stripe_flag
1509: from msd_cs_definitions
1510: where name = p_cs_defn_name;
1511:
1512: cursor c2(p_cs_id in number) is
1513: select dimension_code

Line 2134: from msd_cs_definitions

2130: if (c1_rec.parameter_name is not null) then
2131:
2132: delete from msd_cs_data_ds
2133: where cs_definition_id = (select cs_definition_id
2134: from msd_cs_definitions
2135: where name = c1_rec.parameter_type)
2136: and cs_name = c1_rec.parameter_name
2137: and demand_plan_id = p_demand_plan_id;
2138:

Line 2143: from msd_cs_definitions

2139: else
2140:
2141: delete from msd_cs_data_ds
2142: where cs_definition_id = (select cs_definition_id
2143: from msd_cs_definitions
2144: where name = c1_rec.parameter_type)
2145: and demand_plan_id = p_demand_plan_id;
2146:
2147: end if;

Line 2209: msd_cs_definitions csd

2205: sysdate,
2206: fnd_global.user_id
2207: from msd_dp_parameters mdp,
2208: msd_cs_data_headers csh,
2209: msd_cs_definitions csd
2210: where mdp.parameter_type = csd.name
2211: and csd.cs_definition_id = csh.cs_definition_id
2212: and csh.cs_name = nvl(mdp.parameter_name, csh.cs_name)
2213: and mdp.demand_plan_id = p_demand_plan_id

Line 2675: from msd_cs_definitions mcd

2671: mcd.name,
2672: mcd.multiple_stream_flag,
2673: mcd.stripe_flag,
2674: nvl(mcd.planning_server_view_name, 'MSD_CS_DATA_V')
2675: from msd_cs_definitions mcd
2676: where name = p_name;
2677:
2678: cursor get_dim_col_id (p_cs_id in number) is
2679: SELECT collect_level_id

Line 2899: from msd_cs_definitions mcd

2895: mcd.name,
2896: mcd.multiple_stream_flag,
2897: mcd.stripe_flag,
2898: nvl(mcd.planning_server_view_name,'MSD_CS_DATA_V')
2899: from msd_cs_definitions mcd
2900: where name = p_name;
2901:
2902: cursor get_dim_col_id (p_cs_id in number) is
2903: SELECT collect_level_id