APPS.PSP_RBKPAY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

SELECT      start_date, end_date, payroll_id
FROM        per_time_periods
WHERE       time_period_id = p_time_period_id ;

Line: 17

SELECT  payroll_control_id, status_code, dist_cr_amount,dist_dr_amount
FROM psp_payroll_controls
where time_period_id=p_time_period_id
and payroll_source_code='PAY'
and source_type='O'
union   --- added union for 509002
SELECT  payroll_control_id, status_code, dist_cr_amount,dist_dr_amount
FROM psp_payroll_controls
where parent_payroll_control_id in
   (SELECT  payroll_control_id
FROM psp_payroll_controls
where time_period_id=p_time_period_id
and payroll_source_code='PAY'
and source_type='O');

Line: 41

SELECT payroll_line_id from psp_payroll_lines
where payroll_control_id = g_payroll_control_rec.payroll_control_id;

Line: 125

		      delete from psp_sub_line_reasons where payroll_sub_line_id in
                       (select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id in
                        (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
		       (select payroll_line_id from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id);

Line: 132

		       delete from psp_payroll_lines where payroll_control_id = g_payroll_control_rec.payroll_control_id;

Line: 138

		       delete from psp_payroll_controls where payroll_control_id=g_payroll_control_rec.payroll_control_id;