DBA Data[Home] [Help]

APPS.HXT_TIME_SUMMARY dependencies on HXT_ERRORS_F

Line 1064: DELETE from hxt_errors_f where --SPR C153

1060: end if;
1061: DELETE from hxt_det_hours_worked_f
1062: WHERE parent_id = g_id;
1063:
1064: DELETE from hxt_errors_f where --SPR C153
1065: hrw_id = g_id; --SPR C153
1066: ELSE
1067: if g_debug then
1068: hr_utility.set_location('hxt_time_summary.Delete_Details',30);

Line 1080: UPDATE hxt_errors_f

1076: WHERE rowid in (
1077: SELECT rowid
1078: FROM hxt_det_hours_worked
1079: WHERE parent_id = g_id);
1080: UPDATE hxt_errors_f
1081: SET effective_end_date = g_effective_start_date - 1
1082: WHERE rowid in (
1083: SELECT rowid
1084: FROM hxt_errors