DBA Data[Home] [Help]

APPS.HXT_TIME_DETAIL dependencies on HXT_DAILY_HOURS_WORKED_V

Line 810: FROM hxt_daily_hours_worked_v

806: cursor_tim_id NUMBER
807: )
808: IS
809: SELECT daily_hours
810: FROM hxt_daily_hours_worked_v
811: WHERE work_date || '' = cursor_day_worked AND tim_id = cursor_tim_id;
812:
813: FUNCTION get_weekly_total
814: RETURN NUMBER

Line 4345: FROM hxt_daily_hours_worked_v

4341: SELECT (COUNT (DISTINCT work_date) + 1
4342: ) -- 1 added for current day which may not
4343: -- be in db
4344: INTO consecutive_days
4345: FROM hxt_daily_hours_worked_v
4346: WHERE work_date BETWEEN g_date_worked
4347: - (p_consecutive_days_limit - 1
4348: ) -- start day
4349: AND g_date_worked - 1 -- yesterday

Line 8017: FROM hxt_daily_hours_worked_v

8013: cursor_tim_id NUMBER
8014: )
8015: IS
8016: SELECT daily_hours
8017: FROM hxt_daily_hours_worked_v
8018: WHERE work_date || '' = cursor_day_worked
8019: AND tim_id = cursor_tim_id;
8020:
8021: -- Bug 7359347