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'