DBA Data[Home] [Help]

APPS.WSH_PO_INTEGRATION_GRP dependencies on WSH_ORG_CARRIER_SITES

Line 485: wsh_org_carrier_sites wocs

481: --
482: CURSOR c_GetCarrierLastUpdateDate(p_delId NUMBER) IS
483: SELECT MAX(wcs.last_update_date), MAX(wocs.last_update_date)
484: FROM wsh_new_deliveries wnd, wsh_carrier_sites wcs,
485: wsh_org_carrier_sites wocs
486: WHERE wnd.organization_id = wocs.organization_id
487: AND wcs.carrier_id = wnd.carrier_id
488: AND wnd.delivery_id = p_delId;
489: --