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_COLLECTION dependencies on HXT_ROTATION_SCHEDULES

Line 69: hxt_rotation_schedules rts

65: per_assignments_f asm,
66: hxt_shifts sht,
67: hxt_weekly_work_schedules wws,
68: hxt_work_shifts wsh,
69: hxt_rotation_schedules rts
70: WHERE c_assignment_id = asm.assignment_id
71: AND TRUNC (c_date_worked) BETWEEN TRUNC (asm.effective_start_date)
72: AND TRUNC (asm.effective_end_date)
73: AND ast.assignment_status_type_id = asm.assignment_status_type_id

Line 87: FROM hxt_rotation_schedules

83: AND NVL (wws.date_to, c_date_worked)
84: AND wws.id = rts.tws_id
85: AND sht.id = wsh.sht_id
86: AND rts.start_date = (SELECT MAX (start_date)
87: FROM hxt_rotation_schedules
88: WHERE rtp_id = asmv.hxt_rotation_plan
89: AND start_date <= c_date_worked);
90:
91: CURSOR g_earn_pol_details_cur (c_earn_pol_id NUMBER, c_date_worked DATE)