APPS.HXT_TIME_GEN dependencies on HXT_WEEKLY_WORK_SCHEDULES

Line 459: hxt_weekly_work_schedules wws,

455: SELECT wsh.off_shift_prem_id, wsh.shift_diff_ovrrd_id,
456: sht.standard_start, sht.standard_stop, sht.early_start,
457: sht.late_stop, sht.hours
458: FROM hxt_shifts sht,
459: hxt_weekly_work_schedules wws,
460: hxt_work_shifts wsh
461: WHERE wsh.week_day = hxt_util.get_week_day(a_date)
462: AND wws.id = wsh.tws_id
463: AND a_date BETWEEN wws.date_from AND NVL (wws.date_to, a_date)