APPS.AHL_VWP_VISITS_PVT dependencies on AHL_DEPARTMENT_SHIFTS

Line 3523: FROM AHL_VISITS_B v, AHL_DEPARTMENT_SHIFTS shifts

3519:
3520: --Fetch to find whether task updation is going to happend or not
3521: CURSOR get_visit_data_csr(p_visit_id IN NUMBER) IS
3522: SELECT v.department_id , v.start_date_time
3523: FROM AHL_VISITS_B v, AHL_DEPARTMENT_SHIFTS shifts
3524: WHERE v.department_id = shifts.department_id
3525: AND v.visit_id = p_visit_id;
3526:
3527: l_visit_dept_id NUMBER := NULL;