APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_TASK_LINKS

Line 2077: select link.parent_task_id from ahl_task_links link

2073: -- VWP ER-12424063:: tchimira :: 1-JUN-2011:: start
2074: -- For the passed task id, get all its successive parent tasks
2075: CURSOR c_get_parent_tasks(c_task_id IN NUMBER)
2076: IS
2077: select link.parent_task_id from ahl_task_links link
2078: start with link.visit_task_id = c_task_id
2079: connect by prior link.parent_task_id = link.visit_task_id;
2080:
2081: -- For the passed task id, get all its successive child tasks

Line 2084: select link.visit_task_id from ahl_task_links link

2080:
2081: -- For the passed task id, get all its successive child tasks
2082: CURSOR c_get_child_tasks(c_task_id IN NUMBER)
2083: IS
2084: select link.visit_task_id from ahl_task_links link
2085: start with link.parent_task_id = c_task_id
2086: connect by prior link.visit_task_id = link.parent_task_id;
2087:
2088: --Get stage id for a given task

Line 2567: FROM ahl_task_links

2563:
2564: --Cursor to validate whether task rules does not violate stage rules
2565: CURSOR c_validate_stage_tasks (p_subject_id IN NUMBER, p_object_id IN NUMBER) IS
2566: SELECT 'X'
2567: FROM ahl_task_links
2568: WHERE parent_task_id IN (SELECT visit_task_id FROM ahl_visit_tasks_b WHERE stage_id = p_object_id)
2569: START WITH visit_task_id IN (SELECT visit_task_id FROM ahl_visit_tasks_b WHERE stage_id = p_subject_id)
2570: CONNECT BY PRIOR parent_task_id = visit_task_id;
2571: