APPS.AHL_VWP_TIMES_PVT dependencies on AHL_TASK_LINKS

Line 405: FROM ahl_task_links tl

401: max(vtsk.department_id) department_id
402: FROM AHL_VISIT_TASKS_B vtsk,
403: ahl_routes_app_v routes, ahl_mr_routes_app_v mr,
404: (SELECT visit_task_id, level+1 task_level
405: FROM ahl_task_links tl
406: WHERE visit_task_id in (
407: SELECT visit_task_id from ahl_visit_tasks_b vt
408: where (VT.STATUS_CODE IS NULL OR (VT.STATUS_CODE <> 'DELETED' AND VT.STATUS_CODE <> 'RELEASED')))
409: START WITH tl.parent_task_id in

Line 412: AND vt.visit_task_id not in (SELECT visit_task_id from ahl_task_links)

408: where (VT.STATUS_CODE IS NULL OR (VT.STATUS_CODE <> 'DELETED' AND VT.STATUS_CODE <> 'RELEASED')))
409: START WITH tl.parent_task_id in
410: (SELECT visit_task_id from ahl_visit_tasks_b vt
411: where vt.visit_id=p_visit_id
412: AND vt.visit_task_id not in (SELECT visit_task_id from ahl_task_links)
413: and (VT.STATUS_CODE IS NULL OR (VT.STATUS_CODE <> 'DELETED' AND VT.STATUS_CODE <> 'RELEASED'))
414: AND vt.TASK_TYPE_CODE <> 'SUMMARY')
415: CONNECT BY tl.parent_task_id = prior tl.visit_task_id
416: union

Line 419: WHERE vt.visit_task_id not in (SELECT visit_task_id from ahl_task_links)

415: CONNECT BY tl.parent_task_id = prior tl.visit_task_id
416: union
417: SELECT vt.visit_task_id, 1 task_level
418: FROM ahl_visit_tasks_b vt
419: WHERE vt.visit_task_id not in (SELECT visit_task_id from ahl_task_links)
420: AND vt.visit_id =p_visit_id
421: AND (VT.STATUS_CODE IS NULL OR (VT.STATUS_CODE <> 'DELETED' AND VT.STATUS_CODE <> 'RELEASED'))
422: AND vt.TASK_TYPE_CODE <> 'SUMMARY'
423: ) dtl

Line 435: FROM AHL_VISIT_TASKS_B vt, AHL_TASK_LINKS tl

431: --This cursor uses the technical dependencies and finds the parent task
432: -- that finishes last.
433: CURSOR get_tech_dependency_csr(p_task_id IN NUMBER) IS
434: SELECT max(vt.end_date_time)
435: FROM AHL_VISIT_TASKS_B vt, AHL_TASK_LINKS tl
436: WHERE vt.visit_task_id = tl.parent_task_id
437: AND tl.visit_task_id = p_task_id;
438: --
439:

Line 830: FROM AHL_VISIT_TASKS_B vt, AHL_TASK_LINKS tl

826: --This cursor uses the technical dependencies and finds the parent task
827: -- that finishes last.
828: CURSOR get_tech_dependency_csr(p_task_id IN NUMBER) IS
829: SELECT max(vt.end_date_time)
830: FROM AHL_VISIT_TASKS_B vt, AHL_TASK_LINKS tl
831: WHERE vt.visit_task_id = tl.parent_task_id
832: AND tl.visit_task_id = p_task_id;
833: --
834: --Cursor which fetches all child technical dependent tasks

Line 837: FROM AHL_TASK_LINKS

833: --
834: --Cursor which fetches all child technical dependent tasks
835: CURSOR get_child_dependency_csr(p_task_id IN NUMBER) IS
836: SELECT visit_task_id
837: FROM AHL_TASK_LINKS
838: WHERE parent_task_id = p_task_id;
839: --
840: l_old_task_start DATE; --Existing task start time
841: l_old_task_end DATE; --Existing task end time