DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on WSH_CARRIER_SHIP_METHODS

Line 5081: FROM wsh_carrier_ship_methods csm,

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

Line 9650: from wsh_carrier_ship_methods csm,

9646: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2) is
9647:
9648: Cursor C_Get_ship_method ( l_ship_method_code varchar2, l_org_id number) is
9649: SELECT csm.ship_method_code
9650: from wsh_carrier_ship_methods csm,
9651: fnd_lookup_values fl
9652: where fl.lookup_type = 'SHIP_METHOD'
9653: and csm.ship_method_code = l_ship_method_code
9654: and fl.view_application_id = 3