APPS.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 4952: FROM ahl_unit_effectivities_app_v T1, ahl_visit_tasks_b T2

4948:
4949: -- To find due date for a visit related with tasks
4950: CURSOR c_due_date (x_id IN NUMBER) IS
4951: SELECT MAX(T1.due_date)
4952: FROM ahl_unit_effectivities_app_v T1, ahl_visit_tasks_b T2
4953: WHERE T1.unit_effectivity_id = T2.unit_effectivity_id AND T2.visit_id = x_id;
4954:
4955: BEGIN
4956: -- Standard Start of API savepoint