APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VISIT_TASKS_VL

Line 2331: SELECT * FROM AHL_VISIT_TASKS_VL

2327:
2328: -- To find task related information for a visit
2329: -- Dont copy deleted tasks to new visit.
2330: CURSOR c_task (x_visit_id IN NUMBER) IS
2331: SELECT * FROM AHL_VISIT_TASKS_VL
2332: WHERE VISIT_ID = x_visit_id AND NVL(STATUS_CODE,'X') <> 'DELETED';
2333: c_task_rec c_task%ROWTYPE;
2334:
2335: -- To find task link related information for a visit

Line 2846: SELECT * FROM Ahl_Visit_Tasks_VL

2842: c_Visit_rec c_Visit%ROWTYPE;
2843:
2844: -- To find all tasks under this current visit related information
2845: CURSOR c_Task (x_id IN NUMBER) IS
2846: SELECT * FROM Ahl_Visit_Tasks_VL
2847: WHERE VISIT_ID = x_id
2848: and NVL(status_code, 'X') not in('DELETED', 'CANCELLED');
2849:
2850: c_Task_rec c_Task%ROWTYPE;

Line 4040: FROM Ahl_Visit_Tasks_VL

4036: -- cursor for finding all information about the tasks
4037: CURSOR c_Tasks_csr(x_id IN NUMBER) IS
4038: -- Merge process for 11.5.10 Bug fix
4039: SELECT visit_task_id,object_version_number,visit_task_number
4040: FROM Ahl_Visit_Tasks_VL
4041: WHERE VISIT_ID = x_id AND NVL(STATUS_CODE,'X') <> 'DELETED'
4042: AND ((TASK_TYPE_CODE = 'SUMMARY' AND ORIGINATING_TASK_ID IS NULL)
4043: OR TASK_TYPE_CODE = 'UNASSOCIATED'
4044: OR (TASK_TYPE_CODE = 'SUMMARY' AND MR_ID IS NULL));

Line 4727: SELECT * FROM AHL_VISIT_TASKS_VL

4723: c_visit_rec c_visit%ROWTYPE;
4724:
4725: -- To find task related information
4726: CURSOR c_task (x_id IN NUMBER) IS
4727: SELECT * FROM AHL_VISIT_TASKS_VL
4728: WHERE VISIT_ID = x_id
4729: AND NVL(STATUS_CODE,'X') <> 'DELETED';
4730: c_task_rec c_task%ROWTYPE;
4731:

Line 4740: FROM AHL_VISIT_TASKS_VL A, AHL_WORKORDERS B

4736: -- Filter out all Summary tasks, because Master WO will not have statuses updated
4737: --If found, then can not close job.
4738: CURSOR get_open_job_task_csr (p_visit_id IN NUMBER) IS
4739: SELECT A.VISIT_TASK_ID
4740: FROM AHL_VISIT_TASKS_VL A, AHL_WORKORDERS B
4741: WHERE A.VISIT_TASK_ID = B.VISIT_TASK_ID
4742: AND A.VISIT_ID = p_visit_id
4743: AND NVL(A.STATUS_CODE,'X') <> 'DELETED'
4744: -- Balaji added statuses complete_no_charge and deleted to the list of statuses to be

Line 4771: FROM ahl_visit_tasks_vl a, ahl_workorders b

4767:
4768: --Added by Srini
4769: CURSOR c_wip_entity(c_visit_id IN NUMBER) IS
4770: SELECT A.visit_task_id,workorder_id,wip_entity_id,a.object_version_number
4771: FROM ahl_visit_tasks_vl a, ahl_workorders b
4772: WHERE a.visit_task_id = b.visit_task_id
4773: AND a.visit_id = C_VISIT_ID
4774: AND NVL(A.STATUS_CODE,'X') <> 'DELETED'
4775: AND B.STATUS_CODE <> '7';

Line 4780: FROM ahl_visit_tasks_vl

4776:
4777: -- Get summary task without mr
4778: CURSOR c_summ_task (c_visit_id IN NUMBER) IS
4779: SELECT visit_task_id,object_version_number
4780: FROM ahl_visit_tasks_vl
4781: WHERE visit_id = c_visit_id
4782: AND mr_id IS NULL
4783: AND task_type_code = 'SUMMARY'
4784: AND NVL(STATUS_CODE,'X') <> 'DELETED';

Line 5186: SELECT * FROM AHL_VISIT_TASKS_VL

5182: c_visit_rec c_visit%ROWTYPE;
5183:
5184: -- To find task related information for a visit
5185: CURSOR c_task (x_visit_id IN NUMBER) IS
5186: SELECT * FROM AHL_VISIT_TASKS_VL
5187: WHERE VISIT_ID = x_visit_id
5188: AND NVL(STATUS_CODE,'X') <> 'DELETED';
5189: c_task_rec c_task%ROWTYPE;
5190:

Line 5943: FROM ahl_visit_tasks_vl

5939: l_quarantined VARCHAR2(1);
5940:
5941: CURSOR c_get_tasknumbers (x_visit_id IN NUMBER) IS
5942: SELECT visit_task_number,instance_id
5943: FROM ahl_visit_tasks_vl
5944: WHERE visit_id = x_visit_id
5945: AND NVL(STATUS_CODE,'X') NOT IN ('DELETED','RELEASED')
5946: AND TASK_TYPE_CODE <> 'SUMMARY';
5947: