DBA Data[Home] [Help]

APPS.HXT_TIME_GEN dependencies on HXT_SHIFTS

Line 591: FROM hxt_shifts sht,

587: IS
588: SELECT wsh.off_shift_prem_id, wsh.shift_diff_ovrrd_id,
589: sht.standard_start, sht.standard_stop, sht.early_start,
590: sht.late_stop, sht.hours
591: FROM hxt_shifts sht,
592: hxt_weekly_work_schedules wws,
593: hxt_work_shifts wsh
594: WHERE wsh.week_day = hxt_util.get_week_day(a_date)
595: AND wws.id = wsh.tws_id