DBA Data[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)