The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT dist_dr_amount,dist_cr_amount,payroll_control_id
FROM psp_payroll_controls a
WHERE a.batch_name = p_batch_name
AND a.status_code = 'N'
AND a.business_group_id = p_business_group_id
AND a.set_of_books_id = p_set_of_bks_id;
SELECT payroll_line_id
FROM psp_payroll_lines
WHERE payroll_control_id = c_payroll_control_id;
would be deleted for roll back of non-oracle payroll*******************/
OPEN payroll_id_cur;
DELETE FROM psp_payroll_sub_lines
WHERE payroll_line_id = l_payroll_line_id;
DELETE FROM psp_payroll_lines
WHERE payroll_control_id = c_payroll_control_id;
DELETE FROM psp_payroll_controls
WHERE batch_name = c_batch_name
AND business_group_id = c_business_group_id
AND set_of_books_id = c_set_of_bks_id;
UPDATE psp_payroll_interface SET status_code = 'N'
WHERE batch_name = c_batch_name
AND business_group_id = c_business_group_id
AND set_of_books_id = c_set_of_bks_id;