APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_CALENDAR_DATES

Line 204: FROM msc_calendar_dates

200: WHERE plan_id = p_plan_id;
201:
202: CURSOR seqnum_cursor(p_date DATE) IS
203: SELECT next_seq_num
204: FROM msc_calendar_dates
205: WHERE calendar_code = g_calendar_code
206: AND exception_set_id = g_exc_set_id
207: AND sr_instance_id = g_inst_id
208: AND calendar_date = p_date;

Line 212: FROM msc_calendar_dates

208: AND calendar_date = p_date;
209:
210: CURSOR prior_seqnum_cursor(p_date DATE) IS
211: SELECT prior_seq_num
212: FROM msc_calendar_dates
213: WHERE calendar_code = g_calendar_code
214: AND exception_set_id = g_exc_set_id
215: AND sr_instance_id = g_inst_id
216: AND calendar_date = p_date;

Line 1151: msc_calendar_dates cal

1147: to_char(NULL)
1148: FROM msc_interorg_ship_methods sm,
1149: msc_form_query list,
1150: msc_trading_partners tp,
1151: msc_calendar_dates cal
1152: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
1153: AND cal.exception_set_id = tp.calendar_exception_set_id
1154: AND cal.calendar_code = tp.calendar_code
1155: AND cal.sr_instance_id = tp.sr_instance_id

Line 1179: msc_calendar_dates cal

1175: to_char(NULL)
1176: FROM msc_interorg_ship_methods sm,
1177: msc_form_query list,
1178: msc_trading_partners tp,
1179: msc_calendar_dates cal
1180: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
1181: AND cal.exception_set_id = tp.calendar_exception_set_id
1182: AND cal.calendar_code = tp.calendar_code
1183: AND cal.sr_instance_id = tp.sr_instance_id

Line 1288: msc_calendar_dates cal

1284:
1285: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
1286: SELECT cal.calendar_date
1287: FROM msc_trading_partners tp,
1288: msc_calendar_dates cal
1289: WHERE tp.sr_tp_id = g_org_id
1290: AND tp.sr_instance_id = g_inst_id
1291: AND tp.calendar_exception_set_id = cal.exception_set_id
1292: AND tp.partner_type = 3

Line 1400: from msc_calendar_dates mca,

1396: FUNCTION isWorkDay(p_org_id number, p_inst_id number,
1397: p_date Date) return boolean IS
1398: CURSOR work_c IS
1399: select mca.seq_num
1400: from msc_calendar_dates mca,
1401: msc_trading_partners mtp
1402: where mtp.sr_tp_id = p_org_id
1403: and mtp.sr_instance_id = p_inst_id
1404: and mtp.partner_type = 3