APPS.PSP_RBKPAY dependencies on PSP_SUB_LINE_REASONS

Line 125: delete from psp_sub_line_reasons where payroll_sub_line_id in

121: loop
122: fetch get_payroll_line_csr into g_payroll_line_rec;
123: EXIT when get_payroll_line_csr%NOTFOUND;
124: */
125: delete from psp_sub_line_reasons where payroll_sub_line_id in
126: (select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id in
127: (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id));
128:
129: delete from psp_payroll_sub_lines where payroll_line_id in