DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on CSR_TRIP_TASKS_V

Line 1537: FROM csr_trip_tasks_v

1533: l_planned_effort_minutes NUMBER;
1534:
1535: CURSOR c_overlap_tasks(p_trip_id NUMBER, p_start_date DATE, p_end_date DATE) IS
1536: SELECT NVL(TASK_NUMBER,TASK_ID) overlap_task_num
1537: FROM csr_trip_tasks_v
1538: WHERE object_capacity_id = p_trip_id
1539: AND task_id <> p_task_id
1540: AND NVL(actual_end_date,scheduled_end_date) >= p_start_date
1541: AND NVL(actual_start_date,scheduled_start_date) <= p_end_date;