DBA Data[Home] [Help]

APPS.PSP_ROLLBACK_DIST_LINES dependencies on PSP_DISTRIBUTION_LINES

Line 91: DELETE FROM PSP_DISTRIBUTION_LINES

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