APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_DP_DIMENSIONS

Line 997: from msd_dp_dimensions

993: p_level_id in number) is
994:
995: cursor chk_dim (p_dim_code in varchar2) is
996: select C_TRUE
997: from msd_dp_dimensions
998: where demand_plan_id = p_demand_plan_id
999: and dimension_code = p_dim_code;
1000:
1001: /* ISO Code Change */

Line 1954: from msd_dp_dimensions

1950: p_demand_plan_id in number) return varchar2 is
1951:
1952: cursor chk_change_dim1 is
1953: select dimension_code
1954: from msd_dp_dimensions
1955: where demand_plan_id = p_demand_plan_id
1956: and dimension_code in (C_REP_DIM_CODE,C_GEO_DIM_CODE)
1957: minus
1958: select parameter_type

Line 1972: from msd_dp_dimensions

1968: and data_type = C_DIM
1969: and parameter_type in (C_REP_DIM_CODE,C_GEO_DIM_CODE)
1970: minus
1971: select dimension_code
1972: from msd_dp_dimensions
1973: where demand_plan_id = p_demand_plan_id
1974: and dimension_code in (C_REP_DIM_CODE,C_GEO_DIM_CODE);
1975:
1976: x_dim_code varchar2(30);

Line 2225: from msd_dp_dimensions mdd

2221: sysdate,
2222: fnd_global.user_id,
2223: sysdate,
2224: fnd_global.user_id
2225: from msd_dp_dimensions mdd
2226: where mdd.demand_plan_id = p_demand_plan_id;
2227:
2228: if l_debug = C_YES_FLAG then
2229: debug_out( 'Exiting update_dp_parameters_ds ' || to_char(sysdate, 'hh24:mi:ss'));

Line 3309: from msd_dp_dimensions

3305: function is_dim_in_plan (p_demand_plan_id in number, p_dim_code in varchar2) return varchar2 is
3306:
3307: cursor chk_dim is
3308: select C_TRUE
3309: from msd_dp_dimensions
3310: where dimension_code = p_dim_code
3311: and demand_plan_id = p_demand_plan_id;
3312:
3313: x_is_dim_in_plan varchar2(30) := C_FALSE;