[Home] [Help]
APPS.HXT_UTIL dependencies on HXT_WORK_SHIFTS
Line 707: hxt_work_shifts wsh
703: p_late_stop,
704: p_hours
705: FROM hxt_shifts sht,
706: hxt_weekly_work_schedules wws,
707: hxt_work_shifts wsh
708: WHERE wsh.week_day = hxt_util.get_week_day(p_date)
709: AND wws.id = wsh.tws_id
710: AND p_date between wws.date_from
711: and nvl(wws.date_to, p_date)