DBA Data[Home] [Help]

APPS.CSF_PLANBOARD_TASKS dependencies on CAC_SR_OBJECT_CAPACITY

Line 398: FROM cac_sr_object_capacity

394: ---Newly added code for performance improvement
395: PROCEDURE get_trip_status IS
396: CURSOR c_trip_status IS
397: SELECT object_capacity_id,status
398: FROM cac_sr_object_capacity
399: WHERE object_capacity_id in (select DISTINCT column_value
400: FROM TABLE(CAST(trip_id AS jtf_NUMBER_table))
401: where column_value <> 0);
402: i BINARY_INTEGER := 0;