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_WORK_SHIFTS

Line 1038: -- hxt_work_shifts wsh,

1034: -- per_assignment_status_types ast,
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

Line 1095: hxt_work_shifts hws

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
1098: AND NVL (hrp.date_to, c_date_worked )
1099: AND hrs.rtp_id = hrp.id