APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VISIT_TASKS_VL

Line 2876: SELECT * FROM AHL_VISIT_TASKS_VL

2872:
2873: -- To find task related information for a visit
2874: -- Dont copy deleted tasks to new visit.
2875: CURSOR c_task (x_visit_id IN NUMBER) IS
2876: SELECT * FROM AHL_VISIT_TASKS_VL
2877: WHERE VISIT_ID = x_visit_id AND NVL(STATUS_CODE,'X') <> 'DELETED';
2878: c_task_rec c_task%ROWTYPE;
2879:
2880: -- To find task link related information for a visit

Line 3426: SELECT * FROM Ahl_Visit_Tasks_VL

3422: c_Visit_rec c_Visit%ROWTYPE;
3423:
3424: -- To find all tasks under this current visit related information
3425: CURSOR c_Task (x_id IN NUMBER) IS
3426: SELECT * FROM Ahl_Visit_Tasks_VL
3427: WHERE VISIT_ID = x_id
3428: and NVL(status_code, 'X') not in('DELETED', 'CANCELLED');
3429:
3430: c_Task_rec c_Task%ROWTYPE;

Line 5282: FROM Ahl_Visit_Tasks_VL

5278: -- cursor for finding all information about the tasks
5279: CURSOR c_Tasks_csr(x_id IN NUMBER) IS
5280: -- Merge process for 11.5.10 Bug fix
5281: SELECT visit_task_id,object_version_number,visit_task_number
5282: FROM Ahl_Visit_Tasks_VL
5283: WHERE VISIT_ID = x_id AND NVL(STATUS_CODE,'X') <> 'DELETED'
5284: AND ((TASK_TYPE_CODE = 'SUMMARY' AND ORIGINATING_TASK_ID IS NULL)
5285: OR TASK_TYPE_CODE = 'UNASSOCIATED'
5286: -- SKPATHAK :: 18-Oct-2011 :: Bug 12955463 :: Need to delete the stage tasks also

Line 6304: SELECT * FROM AHL_VISIT_TASKS_VL

6300: c_visit_rec c_visit%ROWTYPE;
6301:
6302: -- To find task related information
6303: CURSOR c_task (x_id IN NUMBER) IS
6304: SELECT * FROM AHL_VISIT_TASKS_VL
6305: WHERE VISIT_ID = x_id
6306: AND NVL(STATUS_CODE,'X') <> 'DELETED';
6307: c_task_rec c_task%ROWTYPE;
6308:

Line 6317: FROM AHL_VISIT_TASKS_VL A, AHL_WORKORDERS B

6313: -- Filter out all Summary tasks, because Master WO will not have statuses updated
6314: --If found, then can not close job.
6315: CURSOR get_open_job_task_csr (p_visit_id IN NUMBER) IS
6316: SELECT A.VISIT_TASK_ID
6317: FROM AHL_VISIT_TASKS_VL A, AHL_WORKORDERS B
6318: WHERE A.VISIT_TASK_ID = B.VISIT_TASK_ID
6319: AND A.VISIT_ID = p_visit_id
6320: AND NVL(A.STATUS_CODE,'X') <> 'DELETED'
6321: -- Balaji added statuses complete_no_charge and deleted to the list of statuses to be

Line 6350: FROM ahl_visit_tasks_vl a, ahl_workorders b

6346:
6347: --Added by Srini
6348: CURSOR c_wip_entity(c_visit_id IN NUMBER) IS
6349: SELECT A.visit_task_id,workorder_id,wip_entity_id,a.object_version_number
6350: FROM ahl_visit_tasks_vl a, ahl_workorders b
6351: WHERE a.visit_task_id = b.visit_task_id
6352: AND a.visit_id = C_VISIT_ID
6353: AND NVL(A.STATUS_CODE,'X') <> 'DELETED'
6354: AND B.STATUS_CODE <> '7';

Line 6359: FROM ahl_visit_tasks_vl

6355:
6356: -- Get summary task without mr
6357: CURSOR c_summ_task (c_visit_id IN NUMBER) IS
6358: SELECT visit_task_id,object_version_number
6359: FROM ahl_visit_tasks_vl
6360: WHERE visit_id = c_visit_id
6361: AND mr_id IS NULL
6362: AND task_type_code = 'SUMMARY'
6363: AND NVL(STATUS_CODE,'X') <> 'DELETED';

Line 6834: SELECT * FROM AHL_VISIT_TASKS_VL

6830: c_visit_rec c_visit%ROWTYPE;
6831:
6832: -- To find task related information for a visit
6833: CURSOR c_task (x_visit_id IN NUMBER) IS
6834: SELECT * FROM AHL_VISIT_TASKS_VL
6835: WHERE VISIT_ID = x_visit_id
6836: AND NVL(STATUS_CODE,'X') <> 'DELETED';
6837: c_task_rec c_task%ROWTYPE;
6838:

Line 7704: FROM ahl_visit_tasks_vl

7700: l_quarantined VARCHAR2(1);
7701:
7702: CURSOR c_get_tasknumbers (x_visit_id IN NUMBER) IS
7703: SELECT visit_task_number,instance_id
7704: FROM ahl_visit_tasks_vl
7705: WHERE visit_id = x_visit_id
7706: AND NVL(STATUS_CODE,'X') NOT IN ('DELETED','RELEASED')
7707: AND TASK_TYPE_CODE <> 'SUMMARY';
7708: