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_ROTATION_SCHEDULES

Line 12651: hxt_rotation_schedules hrs

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
12654: AND aeiv.effective_end_date
12655: AND hrs.rtp_id = aeiv.hxt_rotation_plan

Line 12658: FROM hxt_rotation_schedules

12654: AND aeiv.effective_end_date
12655: AND hrs.rtp_id = aeiv.hxt_rotation_plan
12656: AND hrs.start_date =
12657: (SELECT MAX (start_date)
12658: FROM hxt_rotation_schedules
12659: WHERE rtp_id = hrs.rtp_id AND start_date <= p_date_worked)
12660: AND hws.tws_id = hrs.tws_id
12661: AND hws.week_day = TO_CHAR (p_date_worked, 'DY')
12662: AND hws.sht_id = hs.ID;

Line 12669: INDEX(hrs hxt_rotation_schedules_pk)

12665:
12666: CURSOR csr_test_for_osp (p_assignment_id NUMBER, p_date_worked DATE)
12667: IS
12668: SELECT /*+ ORDERED
12669: INDEX(hrs hxt_rotation_schedules_pk)
12670: USE_NL(aeiv hrs)
12671: USE_NL(hrs hws) */
12672: hws.off_shift_prem_id
12673: FROM hxt_per_aei_ddf_v aeiv,

Line 12674: hxt_rotation_schedules hrs,

12670: USE_NL(aeiv hrs)
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