APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_VISIT_TASKS_VL

Line 2490: SELECT visit_task_id, mr_id FROM ahl_visit_tasks_vl

2486:
2487: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;
2488:
2489: CURSOR summary_tasks_snapshot_csr(p_visit_id IN NUMBER) IS
2490: SELECT visit_task_id, mr_id FROM ahl_visit_tasks_vl
2491: WHERE mr_id IS NULL
2492: AND task_type_code = 'SUMMARY'
2493: AND visit_id = p_visit_id
2494: AND nvl(status_code,'x') <> 'DELETED';

Line 2497: SELECT visit_task_id, mr_id FROM ahl_visit_tasks_vl

2493: AND visit_id = p_visit_id
2494: AND nvl(status_code,'x') <> 'DELETED';
2495:
2496: CURSOR other_tasks_snapshot_csr(p_visit_id IN NUMBER) IS
2497: SELECT visit_task_id, mr_id FROM ahl_visit_tasks_vl
2498: WHERE visit_id = p_visit_id
2499: AND nvl(status_code,'x') <> 'DELETED'
2500: AND NOT (task_type_code = 'SUMMARY' AND mr_id IS NULL);
2501:

Line 2852: from ahl_visit_tasks_vl

2848: is
2849: Select visit_id,
2850: visit_task_id,
2851: originating_task_id
2852: from ahl_visit_tasks_vl
2853: where originating_task_id is null
2854: and visit_id =c_visit_id
2855: and task_type_code ='SUMMARY'
2856: AND NVL(status_code, 'Y') <> NVL ('DELETED', 'X')

Line 2867: From ahl_visit_tasks_vl

2863: Is
2864: Select visit_task_id,
2865: visit_id,
2866: mr_id
2867: From ahl_visit_tasks_vl
2868: where visit_id=c_visit_id
2869: AND NVL(status_code, 'Y') <> NVL ('DELETED', 'X')
2870: and task_type_code='UNASSOCIATED';
2871:

Line 2877: FROM ahl_visit_tasks_vl VST

2873:
2874: --Get min(start_time), max(end_time) for summary tasks
2875: CURSOR get_summary_task_times_csr(p_task_id IN NUMBER)IS
2876: SELECT min(start_date_time), max(end_date_time)
2877: FROM ahl_visit_tasks_vl VST
2878: START WITH visit_task_id = p_task_id
2879: AND NVL(VST.status_code, 'Y') <> NVL ('DELETED', 'X')
2880: CONNECT BY originating_task_id = PRIOR visit_task_id;
2881: --

Line 3378: FROM ahl_visit_tasks_vl vt

3374: IS
3375: SELECT vt.visit_id,
3376: vt.visit_task_id,
3377: vt.visit_task_number
3378: FROM ahl_visit_tasks_vl vt
3379: WHERE vt.visit_id = C_VISIT_ID
3380: AND not (vt.task_type_code = 'SUMMARY' AND VT.mr_id IS NULL)
3381: AND NVL(vt.status_code, 'Y') <> NVL ('DELETED', 'X');
3382: