APPS.AHL_VWP_VISITS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 6336: FROM ahl_unit_effectivities_b UE, ahl_visit_tasks_b VT

6332: -- If there are any which is in wrong status, can not close visit
6333: -- PLANNED tasks can not be canncelled. UMP enforcing that rule
6334: CURSOR get_ue_tasks_csr (p_visit_id IN NUMBER) IS
6335: SELECT UE.unit_effectivity_id
6336: FROM ahl_unit_effectivities_b UE, ahl_visit_tasks_b VT
6337: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
6338: AND nvl(UE.status_code,'x') NOT IN
6339: -- Change by jaramana on 09-MAR-2011
6340: -- Included 'MR-TERMINATE' for bug 11848364

Line 6871: FROM AHL_VISIT_TASKS_B TSK, AHL_UNIT_EFFECTIVITIES_B UE

6867: -- Added by jaramana and skpathak on 05-NOV-2009 for Bug 9095324
6868: -- Get only the top level UEs for all manually planned unit effectivities
6869: CURSOR c_unplanned_task_UEs(p_visit_id IN NUMBER) IS
6870: SELECT TSK.UNIT_EFFECTIVITY_ID
6871: FROM AHL_VISIT_TASKS_B TSK, AHL_UNIT_EFFECTIVITIES_B UE
6872: WHERE TSK.VISIT_ID = p_visit_id
6873: AND TSK.STATUS_CODE <> 'DELETED'
6874: AND TSK.TASK_TYPE_CODE = 'SUMMARY'
6875: AND TSK.ORIGINATING_TASK_ID IS NULL

Line 6894: FROM AHL_UNIT_EFFECTIVITIES_B AUE, AHL_VISIT_TASKS_B AVT

6890: -- Cursor to fetch the UE ID of all unplanned tasks
6891: -- For planned tasks, fetch the UE ID only if the status is null, INIT-DUE or EXCEPTION
6892: CURSOR c_get_ue_id (c_visit_id IN NUMBER) IS
6893: SELECT AUE.UNIT_EFFECTIVITY_ID
6894: FROM AHL_UNIT_EFFECTIVITIES_B AUE, AHL_VISIT_TASKS_B AVT
6895: WHERE AVT.VISIT_ID = c_visit_id
6896: AND AUE.UNIT_EFFECTIVITY_ID = AVT.UNIT_EFFECTIVITY_ID
6897: AND (NVL(AUE.STATUS_CODE, 'OPEN') IN ('OPEN', 'INIT-DUE', 'EXCEPTION')
6898: OR AVT.TASK_TYPE_CODE = 'UNPLANNED');