eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_COMPLETIONS_PVT dependencies on AHL_WORK_LOGIN_TIMES

Line 2742: FROM ahl_work_login_times

2738: p_operation_seq_num NUMBER)
2739: IS
2740: SELECT employee_id,
2741: resource_seq_num
2742: FROM ahl_work_login_times
2743: WHERE workorder_id = p_workorder_id
2744: AND OPERATION_SEQ_NUM = p_operation_seq_num
2745: AND login_level IN ('O','R') -- logout only those employees who are logged in at oper, oper-resrc level.
2746: AND LOGOUT_DATE IS NULL;

Line 3148: FROM ahl_work_login_times

3144: -- here we pick up all employees logged in at all levels.
3145: CURSOR c_get_login_recs(p_workorder_id NUMBER)
3146: IS
3147: SELECT employee_id, operation_seq_num, resource_seq_num
3148: FROM ahl_work_login_times
3149: WHERE workorder_id = p_workorder_id
3150: AND LOGOUT_DATE IS NULL;
3151:
3152: