APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_VISIT_TASKS_VL

Line 2409: SELECT visit_task_id, mr_id FROM ahl_visit_tasks_vl

2405:
2406: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;
2407:
2408: CURSOR summary_tasks_snapshot_csr(p_visit_id IN NUMBER) IS
2409: SELECT visit_task_id, mr_id FROM ahl_visit_tasks_vl
2410: WHERE mr_id IS NULL
2411: AND task_type_code = 'SUMMARY'
2412: AND visit_id = p_visit_id
2413: AND nvl(status_code,'x') <> 'DELETED';

Line 2416: SELECT visit_task_id, mr_id FROM ahl_visit_tasks_vl

2412: AND visit_id = p_visit_id
2413: AND nvl(status_code,'x') <> 'DELETED';
2414:
2415: CURSOR other_tasks_snapshot_csr(p_visit_id IN NUMBER) IS
2416: SELECT visit_task_id, mr_id FROM ahl_visit_tasks_vl
2417: WHERE visit_id = p_visit_id
2418: AND nvl(status_code,'x') <> 'DELETED'
2419: AND NOT (task_type_code = 'SUMMARY' AND mr_id IS NULL);
2420:

Line 2771: from ahl_visit_tasks_vl

2767: is
2768: Select visit_id,
2769: visit_task_id,
2770: originating_task_id
2771: from ahl_visit_tasks_vl
2772: where originating_task_id is null
2773: and visit_id =c_visit_id
2774: and task_type_code ='SUMMARY'
2775: AND NVL(status_code, 'Y') <> NVL ('DELETED', 'X')

Line 2786: From ahl_visit_tasks_vl

2782: Is
2783: Select visit_task_id,
2784: visit_id,
2785: mr_id
2786: From ahl_visit_tasks_vl
2787: where visit_id=c_visit_id
2788: AND NVL(status_code, 'Y') <> NVL ('DELETED', 'X')
2789: and task_type_code='UNASSOCIATED';
2790:

Line 2796: FROM ahl_visit_tasks_vl VST

2792:
2793: --Get min(start_time), max(end_time) for summary tasks
2794: CURSOR get_summary_task_times_csr(p_task_id IN NUMBER)IS
2795: SELECT min(start_date_time), max(end_date_time)
2796: FROM ahl_visit_tasks_vl VST
2797: START WITH visit_task_id = p_task_id
2798: AND NVL(VST.status_code, 'Y') <> NVL ('DELETED', 'X')
2799: CONNECT BY originating_task_id = PRIOR visit_task_id;
2800: --

Line 3297: FROM ahl_visit_tasks_vl vt

3293: IS
3294: SELECT vt.visit_id,
3295: vt.visit_task_id,
3296: vt.visit_task_number
3297: FROM ahl_visit_tasks_vl vt
3298: WHERE vt.visit_id = C_VISIT_ID
3299: AND not (vt.task_type_code = 'SUMMARY' AND VT.mr_id IS NULL)
3300: AND NVL(vt.status_code, 'Y') <> NVL ('DELETED', 'X');
3301: