APPS.HXT_TIMECARD_INFO dependencies on HXT_UTIL

Line 351: WHERE wsh.week_day = hxt_util.get_week_day(p_date)--p_weekday --to_char(p_date,'DY')

347: SELECT sht.standard_start, sht.standard_stop, sht.hours
348: FROM hxt_shifts sht,
349: hxt_weekly_work_schedules wws,
350: hxt_work_shifts wsh
351: WHERE wsh.week_day = hxt_util.get_week_day(p_date)--p_weekday --to_char(p_date,'DY')
352: AND wws.id = wsh.tws_id
353: AND p_date BETWEEN wws.date_from AND NVL (wws.date_to, p_date)
354: AND wws.id = p_work_id
355: AND sht.id = wsh.sht_id;