[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
UPDATE hxt_det_hours_worked_f
SET pay_status = 'C',
last_update_login = l_user_id,
last_update_date = SYSDATE
WHERE ROWID IN
(
/* batch_sum_amounts rows with override Amount<>0, Hours=0*/
SELECT hrw.ROWID
FROM hxt_timecards_x tim, -- commenting out. using sysdate view, now. RTF
hxt_det_hours_worked_x hrw -- commenting out. using sysdate view, now. RTF
-- begin OHMPERFFIX - performance fix done by Bryan Crissman and Damon
-- Grube at OHM. the Where rowid in () or rowid in ()
-- construct was causing large numbers of rows to be
-- returned.
WHERE hrw.parent_id > 0
AND tim.id = hrw.tim_id
AND tim.batch_id = p_batch_id
AND ( ( NVL (hrw.amount, 0) <> 0
AND NVL (hrw.hours, 0) = 0
)
/* batch_sum_amounts_hours rows with override Amount=0, Hours <>0*/
OR ( NVL (hrw.amount, 0) = 0
AND NVL (hrw.hours, 0) <> 0
)
));
SELECT DISTINCT htx.for_person_id, htx.time_period_id,
htx.approv_person_id, htx.auto_gen_flag
FROM hxt_timecards_x htx
WHERE htx.id = p_tim_id;
hxt_batch_val.delete_prev_val_errors (p_tim_id => p_tim_id);