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.

[Home] [Help]

APPS.HXT_TIME_DETAIL dependencies on HXT_ROTATION_SCHEDULES

Line 14526: hxt_rotation_schedules hrs

14522: SELECT hws.off_shift_prem_id
14523: FROM hxt_shifts hs,
14524: hxt_work_shifts hws,
14525: hxt_per_aei_ddf_v aeiv,
14526: hxt_rotation_schedules hrs
14527: WHERE aeiv.assignment_id = p_assignment_id
14528: AND p_date_worked BETWEEN aeiv.effective_start_date
14529: AND aeiv.effective_end_date
14530: AND hrs.rtp_id = aeiv.hxt_rotation_plan

Line 14533: FROM hxt_rotation_schedules

14529: AND aeiv.effective_end_date
14530: AND hrs.rtp_id = aeiv.hxt_rotation_plan
14531: AND hrs.start_date =
14532: (SELECT MAX (start_date)
14533: FROM hxt_rotation_schedules
14534: WHERE rtp_id = hrs.rtp_id AND start_date <= p_date_worked)
14535: AND hws.tws_id = hrs.tws_id
14536: AND hws.week_day = TO_CHAR (p_date_worked, 'DY')
14537: AND hws.sht_id = hs.ID;

Line 14544: INDEX(hrs hxt_rotation_schedules_pk)

14540:
14541: CURSOR csr_test_for_osp (p_assignment_id NUMBER, p_date_worked DATE)
14542: IS
14543: SELECT /*+ ORDERED
14544: INDEX(hrs hxt_rotation_schedules_pk)
14545: USE_NL(aeiv hrs)
14546: USE_NL(hrs hws) */
14547: hws.off_shift_prem_id
14548: FROM hxt_per_aei_ddf_v aeiv,

Line 14549: hxt_rotation_schedules hrs,

14545: USE_NL(aeiv hrs)
14546: USE_NL(hrs hws) */
14547: hws.off_shift_prem_id
14548: FROM hxt_per_aei_ddf_v aeiv,
14549: hxt_rotation_schedules hrs,
14550: hxt_work_shifts hws,
14551: hxt_shifts hs
14552: WHERE aeiv.assignment_id = p_assignment_id
14553: AND p_date_worked BETWEEN aeiv.effective_start_date