DBA Data[Home] [Help]

APPS.HXT_TIME_SUMMARY dependencies on HXT_ERRORS_F

Line 2341: DELETE from hxt_errors_f where --SPR C153

2337: end if;
2338: DELETE from hxt_det_hours_worked_f
2339: WHERE parent_id = g_id;
2340:
2341: DELETE from hxt_errors_f where --SPR C153
2342: hrw_id = g_id; --SPR C153
2343: ELSE
2344: if g_debug then
2345: hr_utility.set_location('hxt_time_summary.Delete_Details',30);

Line 2370: UPDATE hxt_errors_f

2366: AND g_sum_session_date BETWEEN effective_start_date
2367: AND effective_end_date ;
2368:
2369:
2370: UPDATE hxt_errors_f
2371: SET effective_end_date = g_effective_start_date - 1
2372: WHERE rowid in (
2373: SELECT rowid
2374: FROM hxt_errors