DBA Data[Home] [Help]

APPS.FTE_FREIGHT_RATING_PUB dependencies on WSH_ORG_CARRIER_SERVICES

Line 22: FROM wsh_carrier_services a, wsh_org_carrier_services b

18: TYPE rate_tab_type IS TABLE OF rate_rec_type INDEX BY BINARY_INTEGER;
19:
20: CURSOR c_get_ship_method_code (c_carrier_id VARCHAR2, c_mode_of_trans VARCHAR2, c_service_level VARCHAR2, c_org_id NUMBER) IS
21: SELECT a.ship_method_code
22: FROM wsh_carrier_services a, wsh_org_carrier_services b
23: WHERE a.carrier_service_id = b.carrier_service_id
24: AND b.organization_id = c_org_id
25: AND b.enabled_flag = 'Y'
26: AND a.enabled_flag = 'Y'