APPS.AHL_VWP_VISITS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_VL
Line 242: FROM ahl_unit_effectivities_vl T1, ahl_visit_tasks_b T2
238:
239: -- To find due date for a visit related with tasks
240: CURSOR c_due_date (x_id IN NUMBER) IS
241: SELECT MIN(T1.due_date) 242: FROM ahl_unit_effectivities_vl T1, ahl_visit_tasks_b T2 243: WHERE T1.unit_effectivity_id = T2.unit_effectivity_id
244: AND T1.due_date IS NOT NULL AND T2.visit_id = x_id;
245:
246: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Due_by_Date';