APPS.AHL_VWP_TASKS_LINKS_PVT dependencies on AHL_VISITS_VL

Line 885: SELECT Any_Task_Chg_Flag,visit_id FROM Ahl_Visits_VL

881: -- AND VISIT_TASK_NUMBER= p_task_no ;
882:
883: -- Cursor find all details about visit
884: CURSOR c_Visit (p_task_id IN NUMBER) IS
885: SELECT Any_Task_Chg_Flag,visit_id FROM Ahl_Visits_VL
886: WHERE VISIT_ID = (
887: SELECT visit_id FROM AHL_VISIT_TASKS_B
888: WHERE visit_task_id = p_task_id
889: );