DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on HXT_UTIL

Line 80: AND wsh.week_day = hxt_util.get_week_day (c_date_worked)

76: AND TRUNC (c_date_worked) BETWEEN TRUNC (asmv.effective_start_date)
77: AND TRUNC (asmv.effective_end_date)
78: AND asmv.hxt_rotation_plan = rts.rtp_id -- SIR 336
79: -- AND c_date_worked >= rts.start_date
80: AND wsh.week_day = hxt_util.get_week_day (c_date_worked)
81: AND wws.id = wsh.tws_id
82: AND c_date_worked BETWEEN wws.date_from
83: AND NVL (wws.date_to, c_date_worked)
84: AND wws.id = rts.tws_id