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_PER_AEI_DDF_V

Line 2582: ,hxt_per_aei_ddf_v aeiv

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
2585: AND p_DATE_WORKED between aeiv.effective_start_date
2586: and aeiv.effective_end_date

Line 2605: FROM hxt_per_aei_ddf_v aeiv

2601: ld_carryover2 DATE;
2602:
2603: CURSOR Get_Work_plan IS
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