DBA Data[Home] [Help]

APPS.PSP_ROLLBACK_DIST_LINES dependencies on PSP_PAYROLL_LINES

Line 94: select payroll_line_id from psp_payroll_lines

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
95: where payroll_control_id = payroll_control_rec.payroll_control_id));
96: UPDATE PSP_PAYROLL_CONTROLS
97: SET dist_dr_amount = NULL,
98: dist_cr_amount = NULL,