APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_WORK_LOGIN_TIMES

Line 3431: FROM ahl_work_login_times

3427: -- Logout all employees logged in at all levels when cancelling a workorder.
3428: CURSOR c_get_login_recs(p_workorder_id NUMBER)
3429: IS
3430: SELECT employee_id, operation_seq_num, resource_seq_num
3431: FROM ahl_work_login_times
3432: WHERE workorder_id = p_workorder_id
3433: AND LOGOUT_DATE IS NULL;
3434:
3435: -- Fix for bug# 5347560.