APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSD_DEM_DATES

Line 982: FROM msd_dem_dates

978: where plan_id = p_plan_id;
979:
980: CURSOR c3 (p_date IN DATE) IS
981: SELECT end_date
982: FROM msd_dem_dates
983: WHERE p_date BETWEEN start_date AND end_date;
984:
985: l_ret date := null;
986: Begin

Line 1108: * Note: This function requires the table msd_dem_dates to be

1104: /*
1105: * Given, the instance, calendar_code, calendar_date, this function
1106: * returns 1 if the date is the last date in its demantra bucket,
1107: * else returns 2.
1108: * Note: This function requires the table msd_dem_dates to be
1109: * populated.
1110: */
1111: FUNCTION IS_LAST_DATE_IN_BUCKET (
1112: p_sr_instance_id IN NUMBER,

Line 1127: FROM msd_dem_dates mdd,

1123: END IF;
1124:
1125: SELECT max(mcd.calendar_date)
1126: INTO x_max_date
1127: FROM msd_dem_dates mdd,
1128: msc_calendar_dates mcd
1129: WHERE
1130: p_calendar_date BETWEEN mdd.start_date AND mdd.end_date
1131: AND mcd.sr_instance_id = p_sr_instance_id