APPS.AHL_VWP_TASKS_LINKS_PVT dependencies on AHL_VISITS_VL

Line 843: SELECT Any_Task_Chg_Flag,visit_id FROM Ahl_Visits_VL

839: -- AND VISIT_TASK_NUMBER= p_task_no ;
840:
841: -- Cursor find all details about visit
842: CURSOR c_Visit (p_task_id IN NUMBER) IS
843: SELECT Any_Task_Chg_Flag,visit_id FROM Ahl_Visits_VL
844: WHERE VISIT_ID = (
845: SELECT visit_id FROM AHL_VISIT_TASKS_B
846: WHERE visit_task_id = p_task_id
847: );