DBA Data[Home] [Help]

APPS.HXT_TIME_SUMMARY dependencies on HXT_WORK_SHIFTS

Line 2581: ,hxt_work_shifts hws

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

Line 2607: ,hxt_work_shifts hws

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
2610: AND g_DATE_WORKED between aeiv.effective_start_date
2611: and aeiv.effective_end_date