APPS.WSH_CREATE_CARRIERS_PKG dependencies on ORG_FREIGHT_TL

Line 757: UPDATE /*+ index(ORG_FREIGHT_TL ORG_FREIGHT_TL_U1) */ ORG_FREIGHT_TL

753: END IF;
754:
755: --Inserted hint for performance bug 3639958
756: --bug 5598102 creation_date and created_by removed from update statement
757: UPDATE /*+ index(ORG_FREIGHT_TL ORG_FREIGHT_TL_U1) */ ORG_FREIGHT_TL
758: SET description = SUBSTR(P_Carrier_info.CARRIER_NAME,1,80),
759: attribute_category = P_Carrier_info.Attribute_Category,
760: attribute1 = P_Carrier_info.Attribute1,
761: attribute2 = P_Carrier_info.Attribute2,

Line 1741: UPDATE ORG_FREIGHT_TL

1737: UPDATE WSH_CARRIER_VEHICLE_TYPES
1738: SET ASSIGNED_FLAG = 'N'
1739: WHERE CARRIER_ID = p_carrier_id;
1740:
1741: UPDATE ORG_FREIGHT_TL
1742: SET DISABLE_DATE = SYSDATE
1743: WHERE party_id=p_carrier_id and DISABLE_DATE is NULL;
1744: --
1745: IF l_debug_on THEN