DBA Data[Home] [Help]

APPS.HXT_TIMECARD_INFO dependencies on HXT_SHIFTS

Line 348: FROM hxt_shifts sht,

344:
345: CURSOR work_day (p_wp_id NUMBER, p_date DATE) --, p_weekday VARCHAR2)
346: IS
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