DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on CSR_TRIP_TASKS_V

Line 1715: FROM csr_trip_tasks_v

1711: l_planned_effort_minutes NUMBER;
1712:
1713: CURSOR c_overlap_tasks(p_trip_id NUMBER, p_start_date DATE, p_end_date DATE) IS
1714: SELECT NVL(TASK_NUMBER,TASK_ID) overlap_task_num
1715: FROM csr_trip_tasks_v
1716: WHERE object_capacity_id = p_trip_id
1717: AND task_id <> p_task_id
1718: AND NVL(actual_end_date,scheduled_end_date) >= p_start_date
1719: AND NVL(actual_start_date,scheduled_start_date) <= p_end_date;