APPS.CTO_BOM_RTG_PK dependencies on BOM_CALENDAR_DATES

Line 803: from bom_calendar_dates cal,

799: lStmtNum := 114;
800: begin
801: select CAL.CALENDAR_DATE
802: into lEstRelDate
803: from bom_calendar_dates cal,
804: mtl_system_items msi,
805: bom_cto_order_lines bcol,
806: mtl_parameters mp
807: where msi.organization_id = lNextRec.organization_id

Line 816: from bom_calendar_dates cal2

812: and cal.calendar_code = mp.calendar_code
813: and cal.exception_set_id = mp.calendar_exception_set_id
814: and cal.seq_num =
815: (select cal2.prior_seq_num - lLeadTime
816: from bom_calendar_dates cal2
817: where cal2.calendar_code = mp.calendar_code
818: and cal2.exception_set_id = mp.calendar_exception_set_id
819: and cal2.calendar_date = trunc(bcol.schedule_ship_date));
820: exception