DBA Data[Home] [Help]

APPS.WSH_FTE_INTEGRATION dependencies on FTE_VEHICLE_TYPES

Line 766: -- Purpose : Gets vehicle type ID from FTE_VEHICLE_TYPES

762: END get_cc_object_name ;
763:
764:
765: -- Procedure : Get_Vehicle_Type
766: -- Purpose : Gets vehicle type ID from FTE_VEHICLE_TYPES
767:
768: PROCEDURE Get_Vehicle_Type(
769: p_vehicle_item_id IN NUMBER,
770: p_vehicle_org_id IN NUMBER,

Line 776: FROM fte_vehicle_types

772: x_return_status OUT NOCOPY VARCHAR2) IS
773:
774: CURSOR get_vehicle_type IS
775: SELECT vehicle_type_id
776: FROM fte_vehicle_types
777: WHERE inventory_item_id = p_vehicle_item_id AND
778: organization_id = p_vehicle_org_id;
779:
780: BEGIN