APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_CALENDAR_DATES

Line 1150: from bom_calendar_dates cal,

1146: lStmtNum := 20;
1147: BEGIN
1148: select CAL.CALENDAR_DATE
1149: into lEstRelDate
1150: from bom_calendar_dates cal,
1151: mtl_system_items msi,
1152: bom_cto_order_lines_upg bcolu,
1153: mtl_parameters mp
1154: where msi.organization_id = pOrgId

Line 1163: from bom_calendar_dates cal2

1159: and cal.calendar_code = mp.calendar_code
1160: and cal.exception_set_id = mp.calendar_exception_set_id
1161: and cal.seq_num =
1162: (select cal2.prior_seq_num - pLeadTime
1163: from bom_calendar_dates cal2
1164: where cal2.calendar_code = mp.calendar_code
1165: and cal2.exception_set_id = mp.calendar_exception_set_id
1166: and cal2.calendar_date = trunc(bcolu.schedule_ship_date));
1167: EXCEPTION