DBA Data[Home] [Help]

APPS.HXT_TIME_SUMMARY dependencies on HXT_WORK_SHIFTS

Line 1289: ,hxt_work_shifts hws

1285: /*CURSOR Get_shift_stop_time (p_assignment_id NUMBER
1286: ,p_date_worked DATE ) IS
1287: SELECT hs.standard_stop
1288: FROM hxt_shifts hs
1289: ,hxt_work_shifts hws
1290: ,hxt_per_aei_ddf_v aeiv
1291: ,hxt_rotation_schedules rts
1292: WHERE aeiv.assignment_id = p_ASSIGNMENT_ID
1293: AND p_DATE_WORKED between aeiv.effective_start_date

Line 1315: ,hxt_work_shifts hws

1311: CURSOR Get_Work_plan IS
1312: SELECT hs.standard_start , hs.standard_stop
1313: FROM hxt_per_aei_ddf_v aeiv
1314: ,hxt_rotation_schedules rts
1315: ,hxt_work_shifts hws
1316: ,hxt_shifts hs
1317: WHERE aeiv.assignment_id = g_ASSIGNMENT_ID
1318: AND g_DATE_WORKED between aeiv.effective_start_date
1319: and aeiv.effective_end_date