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_SUMMARY dependencies on HXT_SHIFTS

Line 2580: FROM hxt_shifts hs

2576:
2577: /*CURSOR Get_shift_stop_time (p_assignment_id NUMBER
2578: ,p_date_worked DATE ) IS
2579: SELECT hs.standard_stop
2580: FROM hxt_shifts hs
2581: ,hxt_work_shifts hws
2582: ,hxt_per_aei_ddf_v aeiv
2583: ,hxt_rotation_schedules rts
2584: WHERE aeiv.assignment_id = p_ASSIGNMENT_ID

Line 2597: ln_standard_start hxt_shifts.standard_start%TYPE;

2593: AND hws.tws_id = rts.tws_id
2594: AND hws.week_day = to_char(p_DATE_WORKED,'DY')
2595: AND hws.sht_id = hs.id;
2596: */
2597: ln_standard_start hxt_shifts.standard_start%TYPE;
2598: ln_standard_stop hxt_shifts.standard_stop%TYPE;
2599: wp_start_time DATE;
2600: wp_stop_time DATE;
2601: ld_carryover2 DATE;

Line 2598: ln_standard_stop hxt_shifts.standard_stop%TYPE;

2594: AND hws.week_day = to_char(p_DATE_WORKED,'DY')
2595: AND hws.sht_id = hs.id;
2596: */
2597: ln_standard_start hxt_shifts.standard_start%TYPE;
2598: ln_standard_stop hxt_shifts.standard_stop%TYPE;
2599: wp_start_time DATE;
2600: wp_stop_time DATE;
2601: ld_carryover2 DATE;
2602:

Line 2608: ,hxt_shifts hs

2604: SELECT hs.standard_start , hs.standard_stop
2605: FROM hxt_per_aei_ddf_v aeiv
2606: ,hxt_rotation_schedules rts
2607: ,hxt_work_shifts hws
2608: ,hxt_shifts hs
2609: WHERE aeiv.assignment_id = g_ASSIGNMENT_ID
2610: AND g_DATE_WORKED between aeiv.effective_start_date
2611: and aeiv.effective_end_date
2612: AND rts.rtp_id = aeiv.hxt_rotation_plan