[Home] [Help]
86: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
87: IF cnt = 0 /* lines not yet processed */
88: THEN
89: BEGIN
90: DELETE FROM PSP_DISTRIBUTION_LINES
91: WHERE payroll_sub_line_id in (select payroll_sub_line_id
92: from psp_payroll_sub_lines
93: where payroll_line_id in (
94: select payroll_line_id from psp_payroll_lines