APPS.MSC_ATP_FUNC dependencies on MSC_CALENDAR

Line 342: FROM msc_calendar_dates c2,

338: END IF;
339: -- End Bug 2877340, 2746213
340: SELECT c2.calendar_date
341: INTO l_infinite_time_fence_date
342: FROM msc_calendar_dates c2,
343: msc_calendar_dates c1,
344: msc_atp_rules r,
345: msc_trading_partners tp,
346: msc_system_items i

Line 343: msc_calendar_dates c1,

339: -- End Bug 2877340, 2746213
340: SELECT c2.calendar_date
341: INTO l_infinite_time_fence_date
342: FROM msc_calendar_dates c2,
343: msc_calendar_dates c1,
344: msc_atp_rules r,
345: msc_trading_partners tp,
346: msc_system_items i
347: WHERE i.sr_inventory_item_id = p_inventory_item_id

Line 689: FROM msc_calendar_dates cal,

685:
686: BEGIN
687: SELECT cal.prior_date
688: INTO l_date
689: FROM msc_calendar_dates cal,
690: msc_trading_partners tp
691: WHERE cal.exception_set_id = tp.calendar_exception_set_id
692: AND cal.calendar_code = tp.calendar_code
693: AND cal.calendar_date = TRUNC(p_date)

Line 782: FROM MSC_CALENDAR_DATES C,

778:
779: BEGIN
780: SELECT C.NEXT_SEQ_NUM
781: INTO l_seq_num
782: FROM MSC_CALENDAR_DATES C,
783: MSC_TRADING_PARTNERS TP
784: WHERE TP.SR_TP_ID = p_organization_id
785: AND TP.SR_INSTANCE_ID = p_instance_id
786: AND TP.PARTNER_TYPE = 3

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

960: BEGIN
961: IF (customer_id IS NOT NULL) THEN
962: RETURN SCH_SHIP_DATE + NVL(delivery_lead_time,0);
963: ELSE
964: l_offset_date := MSC_CALENDAR.DATE_OFFSET (org_id,
965: instance_id,
966: bucket_type,
967: sch_ship_date,
968: NVL(delivery_lead_time, 0));