APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_CALENDAR_DATES

Line 184: FROM msc_calendar_dates

180: WHERE plan_id = p_plan_id;
181:
182: CURSOR seqnum_cursor(p_date DATE) IS
183: SELECT next_seq_num
184: FROM msc_calendar_dates
185: WHERE calendar_code = g_calendar_code
186: AND exception_set_id = g_exc_set_id
187: AND sr_instance_id = g_inst_id
188: AND calendar_date = p_date;

Line 192: FROM msc_calendar_dates

188: AND calendar_date = p_date;
189:
190: CURSOR prior_seqnum_cursor(p_date DATE) IS
191: SELECT prior_seq_num
192: FROM msc_calendar_dates
193: WHERE calendar_code = g_calendar_code
194: AND exception_set_id = g_exc_set_id
195: AND sr_instance_id = g_inst_id
196: AND calendar_date = p_date;

Line 976: msc_calendar_dates cal

972: to_char(NULL)
973: FROM msc_interorg_ship_methods sm,
974: msc_form_query list,
975: msc_trading_partners tp,
976: msc_calendar_dates cal
977: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
978: AND cal.exception_set_id = tp.calendar_exception_set_id
979: AND cal.calendar_code = tp.calendar_code
980: AND cal.sr_instance_id = tp.sr_instance_id

Line 1004: msc_calendar_dates cal

1000: to_char(NULL)
1001: FROM msc_interorg_ship_methods sm,
1002: msc_form_query list,
1003: msc_trading_partners tp,
1004: msc_calendar_dates cal
1005: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
1006: AND cal.exception_set_id = tp.calendar_exception_set_id
1007: AND cal.calendar_code = tp.calendar_code
1008: AND cal.sr_instance_id = tp.sr_instance_id

Line 1113: msc_calendar_dates cal

1109:
1110: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
1111: SELECT cal.calendar_date
1112: FROM msc_trading_partners tp,
1113: msc_calendar_dates cal
1114: WHERE tp.sr_tp_id = g_org_id
1115: AND tp.sr_instance_id = g_inst_id
1116: AND tp.calendar_exception_set_id = cal.exception_set_id
1117: AND tp.partner_type = 3

Line 1225: from msc_calendar_dates mca,

1221: FUNCTION isWorkDay(p_org_id number, p_inst_id number,
1222: p_date Date) return boolean IS
1223: CURSOR work_c IS
1224: select mca.seq_num
1225: from msc_calendar_dates mca,
1226: msc_trading_partners mtp
1227: where mtp.sr_tp_id = p_org_id
1228: and mtp.sr_instance_id = p_inst_id
1229: and mtp.partner_type = 3