APPS.PSP_NON_ORCL_RLBK_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

	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;

Line: 82

       SELECT payroll_line_id
       FROM   psp_payroll_lines
       WHERE  payroll_control_id = c_payroll_control_id;

Line: 90

                       would be deleted for roll back of non-oracle payroll*******************/

    OPEN payroll_id_cur;

Line: 101

        DELETE FROM psp_payroll_sub_lines
        WHERE payroll_line_id = l_payroll_line_id;

Line: 106

       DELETE FROM psp_payroll_lines
        WHERE payroll_control_id = c_payroll_control_id;

Line: 109

       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;

Line: 116

       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;