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.HXT_TIME_CLOCK dependencies on HXT_ROTATION_SCHEDULES

Line 1039: -- hxt_rotation_schedules rts

1035: -- per_assignments_f asm,
1036: -- hxt_shifts sht,
1037: -- hxt_weekly_work_schedules wws,
1038: -- hxt_work_shifts wsh,
1039: -- hxt_rotation_schedules rts
1040: -- WHERE c_assignment_id = asm.assignment_id
1041: -- AND ast.assignment_status_type_id = asm.assignment_status_type_id
1042: -- AND ast.pay_system_status = 'P' -- Check payroll status
1043: --ORACLE AND asmv.row_id = asm.rowid

Line 1093: hxt_rotation_schedules hrs,

1089: -- ***** Start new code for Bug 2669059 **************
1090: CURSOR l_wsh_details_cur(c_hxt_rotation_plan NUMBER, c_date_worked DATE) IS
1091: SELECT hws.off_shift_prem_id, hws.shift_diff_ovrrd_id
1092: FROM hxt_rotation_plans hrp,
1093: hxt_rotation_schedules hrs,
1094: hxt_weekly_work_schedules hwws,
1095: hxt_work_shifts hws
1096: WHERE hrp.id = c_hxt_rotation_plan
1097: AND c_date_worked BETWEEN hrp.date_from