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_DETAIL dependencies on HXT_WORK_SHIFTS

Line 12649: hxt_work_shifts hws,

12645: CURSOR csr_test_for_osp (p_assignment_id NUMBER, p_date_worked DATE)
12646: IS
12647: SELECT hws.off_shift_prem_id
12648: FROM hxt_shifts hs,
12649: hxt_work_shifts hws,
12650: hxt_per_aei_ddf_v aeiv,
12651: hxt_rotation_schedules hrs
12652: WHERE aeiv.assignment_id = p_assignment_id
12653: AND p_date_worked BETWEEN aeiv.effective_start_date

Line 12675: hxt_work_shifts hws,

12671: USE_NL(hrs hws) */
12672: hws.off_shift_prem_id
12673: FROM hxt_per_aei_ddf_v aeiv,
12674: hxt_rotation_schedules hrs,
12675: hxt_work_shifts hws,
12676: hxt_shifts hs
12677: WHERE aeiv.assignment_id = p_assignment_id
12678: AND p_date_worked BETWEEN aeiv.effective_start_date
12679: AND aeiv.effective_end_date