APPS.MSD_DEM_SOP dependencies on MSC_PLAN_BUCKETS

Line 73: * Gets the start date from msc_plan_buckets

69:
70: /* This function returns the start date for the aggregration period.
71: * Gets the aggreration level set for Maintenance WO plan option
72: * 1 = Individual, 2 = Aggregation
73: * Gets the start date from msc_plan_buckets
74: * bucket_type: 1 = daily, 2 = week, 3 = period
75: */
76:
77: FUNCTION GET_AGGREGATION_START_DATE (p_plan_id in number)

Line 110: from msc_plan_buckets

106:
107: ELSIF ((l_daily_mwo_aggr_lvl = 1) AND (l_weekly_mwo_aggr_lvl = 2) AND (l_PERIOD_mwo_aggr_lvl =2)) then
108:
109: select min(bkt_start_date) into l_aggregation_start_date
110: from msc_plan_buckets
111: where plan_id = p_plan_id and bucket_type = 2 ;
112:
113: ELSIF ((l_daily_mwo_aggr_lvl = 1) AND (l_weekly_mwo_aggr_lvl = 1) AND (l_PERIOD_mwo_aggr_lvl =2)) then
114:

Line 116: from msc_plan_buckets

112:
113: ELSIF ((l_daily_mwo_aggr_lvl = 1) AND (l_weekly_mwo_aggr_lvl = 1) AND (l_PERIOD_mwo_aggr_lvl =2)) then
114:
115: select min(bkt_start_date) into l_aggregation_start_date
116: from msc_plan_buckets
117: where plan_id = p_plan_id and bucket_type = 3 ;
118:
119: ELSIF ((l_daily_mwo_aggr_lvl is NULL ) AND (l_weekly_mwo_aggr_lvl is NULL ) AND (l_PERIOD_mwo_aggr_lvl is NULL )) then
120: RETURN nvl(l_aggregation_start_date,l_end_date);