eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_TIME_DETAIL dependencies on HXT_DAILY_HOURS_WORKED_V

Line 691: FROM hxt_daily_hours_worked_v

687: cursor_tim_id NUMBER
688: )
689: IS
690: SELECT daily_hours
691: FROM hxt_daily_hours_worked_v
692: WHERE work_date || '' = cursor_day_worked AND tim_id = cursor_tim_id;
693:
694: FUNCTION get_weekly_total
695: RETURN NUMBER

Line 3152: FROM hxt_daily_hours_worked_v

3148: SELECT (COUNT (DISTINCT work_date) + 1
3149: ) -- 1 added for current day which may not
3150: -- be in db
3151: INTO consecutive_days
3152: FROM hxt_daily_hours_worked_v
3153: WHERE work_date BETWEEN g_date_worked
3154: - (p_consecutive_days_limit - 1
3155: ) -- start day
3156: AND g_date_worked - 1 -- yesterday

Line 6438: FROM hxt_daily_hours_worked_v

6434: cursor_tim_id NUMBER
6435: )
6436: IS
6437: SELECT daily_hours
6438: FROM hxt_daily_hours_worked_v
6439: WHERE work_date || '' = cursor_day_worked
6440: AND tim_id = cursor_tim_id;
6441:
6442: CURSOR weekly_earn_category_total --(cp_earning_category VARCHAR2) BUG 5499459