APPS.AHL_VWP_TIMES_PVT dependencies on AHL_VWP_STAGES_VL

Line 388: from ahl_vwp_stages_vl

384: CURSOR get_stage_data_csr(P_VISIT_ID IN number)
385: IS
386: SELECT stage_id, duration
387: --, sum(duration) over(order by stage_num) CUMUL_DURATION
388: from ahl_vwp_stages_vl
389: where visit_id = p_visit_id
390: order by stage_num;
391: -----------
392: --Fetch the tasks for the visit in tech dependency sorted sequence

Line 686: from ahl_vwp_stages_vl st, ahl_visit_tasks_b vt

682: CURSOR get_stage_data_csr(p_task_ID IN number)
683: IS
684: SELECT st.stage_id, st.duration
685: --, sum(st.duration) over(order by st.stage_num) CUMUL_DURATION
686: from ahl_vwp_stages_vl st, ahl_visit_tasks_b vt
687: where st.visit_id = vt.visit_id
688: AND vt.visit_task_id = p_task_id
689: order by st.stage_num;
690: -- Define local variables