APPS.MSC_ATP_FUNC dependencies on MSC_CALENDAR

Line 334: FROM msc_calendar_dates c2,

330: END IF;
331: -- End Bug 2877340, 2746213
332: SELECT c2.calendar_date
333: INTO l_infinite_time_fence_date
334: FROM msc_calendar_dates c2,
335: msc_calendar_dates c1,
336: msc_atp_rules r,
337: msc_trading_partners tp,
338: msc_system_items i

Line 335: msc_calendar_dates c1,

331: -- End Bug 2877340, 2746213
332: SELECT c2.calendar_date
333: INTO l_infinite_time_fence_date
334: FROM msc_calendar_dates c2,
335: msc_calendar_dates c1,
336: msc_atp_rules r,
337: msc_trading_partners tp,
338: msc_system_items i
339: WHERE i.sr_inventory_item_id = p_inventory_item_id

Line 681: FROM msc_calendar_dates cal,

677:
678: BEGIN
679: SELECT cal.prior_date
680: INTO l_date
681: FROM msc_calendar_dates cal,
682: msc_trading_partners tp
683: WHERE cal.exception_set_id = tp.calendar_exception_set_id
684: AND cal.calendar_code = tp.calendar_code
685: AND cal.calendar_date = TRUNC(p_date)

Line 774: FROM MSC_CALENDAR_DATES C,

770:
771: BEGIN
772: SELECT C.NEXT_SEQ_NUM
773: INTO l_seq_num
774: FROM MSC_CALENDAR_DATES C,
775: MSC_TRADING_PARTNERS TP
776: WHERE TP.SR_TP_ID = p_organization_id
777: AND TP.SR_INSTANCE_ID = p_instance_id
778: AND TP.PARTNER_TYPE = 3

Line 956: l_offset_date := MSC_CALENDAR.DATE_OFFSET (org_id,

952: BEGIN
953: IF (customer_id IS NOT NULL) THEN
954: RETURN SCH_SHIP_DATE + NVL(delivery_lead_time,0);
955: ELSE
956: l_offset_date := MSC_CALENDAR.DATE_OFFSET (org_id,
957: instance_id,
958: bucket_type,
959: sch_ship_date,
960: NVL(delivery_lead_time, 0));