DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on WSH_CARRIER_SHIP_METHODS

Line 5084: FROM wsh_carrier_ship_methods csm,

5080: RETURN VARCHAR2
5081: IS
5082: CURSOR C_ship_method_code (p_org_id NUMBER) IS
5083: SELECT start_date_active, end_date_active
5084: FROM wsh_carrier_ship_methods csm,
5085: fnd_lookup_values fl
5086: WHERE csm.ship_method_code = p_ship_method_code
5087: AND csm.organization_id = p_org_id
5088: AND csm.enabled_flag = 'Y'

Line 9698: from wsh_carrier_ship_methods csm,

9694: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2) is
9695:
9696: Cursor C_Get_ship_method ( l_ship_method_code varchar2, l_org_id number) is
9697: SELECT csm.ship_method_code
9698: from wsh_carrier_ship_methods csm,
9699: fnd_lookup_values fl
9700: where fl.lookup_type = 'SHIP_METHOD'
9701: and csm.ship_method_code = l_ship_method_code
9702: and fl.view_application_id = 3