DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_ORG_CARRIER_SERVICES

Line 1222: FROM wsh_carriers wc,wsh_carrier_services wcs,wsh_org_carrier_services wocs

1218:
1219: ---BUG No:4241880.Cursor changed
1220: CURSOR get_freight(p_ship_method_code VARCHAR2,p_organization_id NUMBER) IS
1221: SELECT freight_code
1222: FROM wsh_carriers wc,wsh_carrier_services wcs,wsh_org_carrier_services wocs
1223: WHERE wc.carrier_id=wcs.carrier_id AND
1224: wcs.carrier_service_id=wocs.carrier_service_id AND
1225: wcs.ship_method_code = p_ship_method_code AND
1226: wocs.organization_id = p_organization_id;

Line 1917: FROM wsh_carrier_services wcs, wsh_org_carrier_services wocs

1913:
1914: ---BUG No:4241880.Cursor changed
1915: CURSOR org_ship_method (l_organization_id NUMBER,l_ship_method_code VARCHAR2) IS
1916: SELECT ship_method_code
1917: FROM wsh_carrier_services wcs, wsh_org_carrier_services wocs
1918: WHERE wocs.organization_id=l_organization_id
1919: and wocs.carrier_service_id=wcs.carrier_service_id
1920: AND wcs.ship_method_code=l_ship_method_code;
1921: ---BUG No:4241880.Cursor changed ends