DBA Data[Home] [Help]

APPS.PSP_RBKPAY dependencies on PSP_PAYROLL_SUB_LINES

Line 126: (select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id in

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
130: (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id);

Line 129: delete from psp_payroll_sub_lines where payroll_line_id in

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
130: (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id);
131:
132: delete from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id;
133: