APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_DEPARTMENT_SHIFTS
Line 4486: SELECT COUNT(*) FROM AHL_DEPARTMENT_SHIFTS
4482: c_visit_rec c_visit%ROWTYPE;
4483:
4484: -- To find visit dept has any dept shifts
4485: CURSOR c_dept (x_id IN NUMBER) IS 4486: SELECT COUNT(*) FROM AHL_DEPARTMENT_SHIFTS 4487: WHERE DEPARTMENT_ID = x_id;
4488:
4489: /* Begin Changes by Shkalyan */
4490: -- To find task related information