APPS.MSC_ATP_FUNC dependencies on MSC_CALENDAR_DATES

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