APPS.AHL_EAM_JOB_PVT dependencies on AHL_VISIT_TASKS_B

Line 133: FROM ahl_visit_tasks_b vst

129:
130: -- cursor to get the Unit_eff ID from task ID
131: CURSOR get_ue_id_csr (p_task_id IN NUMBER) IS
132: SELECT unit_effectivity_id
133: FROM ahl_visit_tasks_b vst
134: WHERE visit_task_id = p_task_id;
135:
136:
137: -- Cursor to get UE details only for a top UE ID.