79: c_business_group_id IN NUMBER,c_set_of_bks_id IN NUMBER) IS
80:
81: CURSOR payroll_id_cur IS
82: SELECT payroll_line_id
83: FROM psp_payroll_lines
84: WHERE payroll_control_id = c_payroll_control_id;
85:
86: l_payroll_line_id NUMBER;
87:
102: WHERE payroll_line_id = l_payroll_line_id;
103:
104: END LOOP;
105:
106: DELETE FROM psp_payroll_lines
107: WHERE payroll_control_id = c_payroll_control_id;
108:
109: DELETE FROM psp_payroll_controls
110: WHERE batch_name = c_batch_name