APPS.AHL_COMPLETIONS_PVT dependencies on AHL_WORK_LOGIN_TIMES

Line 2855: FROM ahl_work_login_times

2851: p_operation_seq_num NUMBER)
2852: IS
2853: SELECT employee_id,
2854: resource_seq_num
2855: FROM ahl_work_login_times
2856: WHERE workorder_id = p_workorder_id
2857: AND OPERATION_SEQ_NUM = p_operation_seq_num
2858: AND login_level IN ('O','R') -- logout only those employees who are logged in at oper, oper-resrc level.
2859: AND LOGOUT_DATE IS NULL;

Line 3261: FROM ahl_work_login_times

3257: -- here we pick up all employees logged in at all levels.
3258: CURSOR c_get_login_recs(p_workorder_id NUMBER)
3259: IS
3260: SELECT employee_id, operation_seq_num, resource_seq_num
3261: FROM ahl_work_login_times
3262: WHERE workorder_id = p_workorder_id
3263: AND LOGOUT_DATE IS NULL;
3264:
3265: