DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on HXT_WORK_SHIFTS

Line 703: hxt_work_shifts wsh

699: p_late_stop,
700: p_hours
701: FROM hxt_shifts sht,
702: hxt_weekly_work_schedules wws,
703: hxt_work_shifts wsh
704: WHERE wsh.week_day = hxt_util.get_week_day(p_date)
705: AND wws.id = wsh.tws_id
706: AND p_date between wws.date_from
707: and nvl(wws.date_to, p_date)