APPS.WSH_CREATE_CARRIERS_PKG dependencies on WSH_ORG_CARRIER_SITES

Line 1393: WSH_ORG_CARRIER_SITES WOCS

1389: WCS.ENABLE_AUTO_TENDER, -- R12 Code changes
1390: WCS.TENDER_TRANSMISSION_METHOD
1391: FROM
1392: WSH_CARRIER_SITES WCS,
1393: WSH_ORG_CARRIER_SITES WOCS
1394: WHERE
1395: WCS.CARRIER_ID = p_carrier_id AND
1396: WOCS.ORGANIZATION_ID = p_organization_id AND
1397: WOCS.CARRIER_SITE_ID = WCS.CARRIER_SITE_ID AND

Line 1710: UPDATE WSH_ORG_CARRIER_SITES

1706:
1707: l_position := 40;
1708: l_procedure := 'Unassigning Org from Carrier Sites';
1709: -- Unassigning Org from Carrier Sites
1710: UPDATE WSH_ORG_CARRIER_SITES
1711: SET ENABLED_FLAG = 'N'
1712: WHERE CARRIER_SITE_ID = l_carrier_site_id;
1713:
1714: l_position := 50;