APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_VISIT_TASKS_B

Line 15310: from ahl_visits_b vst, ahl_visit_tasks_b tsk

15306:
15307: -- get visit end date
15308: CURSOR get_vst_date(p_ue_id IN NUMBER) IS
15309: SELECT vst.close_date_time
15310: from ahl_visits_b vst, ahl_visit_tasks_b tsk
15311: where tsk.unit_effectivity_id = p_ue_id
15312: and tsk.visit_id = vst.visit_id
15313: and tsk.task_type_code = 'SUMMARY';
15314: