APPS.PSP_RBKPAY dependencies on PSP_PAYROLL_CONTROLS

Line 18: FROM psp_payroll_controls

14: WHERE time_period_id = p_time_period_id ;
15:
16: CURSOR get_payroll_control_id_csr is
17: SELECT payroll_control_id, status_code, dist_cr_amount,dist_dr_amount
18: FROM psp_payroll_controls
19: where time_period_id=p_time_period_id
20: and payroll_source_code='PAY'
21: and source_type='O'
22: union --- added union for 509002

Line 24: FROM psp_payroll_controls

20: and payroll_source_code='PAY'
21: and source_type='O'
22: union --- added union for 509002
23: SELECT payroll_control_id, status_code, dist_cr_amount,dist_dr_amount
24: FROM psp_payroll_controls
25: where parent_payroll_control_id in
26: (SELECT payroll_control_id
27: FROM psp_payroll_controls
28: where time_period_id=p_time_period_id

Line 27: FROM psp_payroll_controls

23: SELECT payroll_control_id, status_code, dist_cr_amount,dist_dr_amount
24: FROM psp_payroll_controls
25: where parent_payroll_control_id in
26: (SELECT payroll_control_id
27: FROM psp_payroll_controls
28: where time_period_id=p_time_period_id
29: and payroll_source_code='PAY'
30: and source_type='O');
31:

Line 138: delete from psp_payroll_controls where payroll_control_id=g_payroll_control_rec.payroll_control_id;

134: --Bug 3950282 : removed the cursor get_payroll_line_csr; Deleting records based on control id's.
135: -- end loop;
136: -- close get_payroll_line_csr;
137:
138: delete from psp_payroll_controls where payroll_control_id=g_payroll_control_rec.payroll_control_id;
139: END IF;
140: END IF;
141: END LOOP;
142:

Line 146: Summarize and transfer may have been run : If all the records in psp_payroll_controls are

142:
143:
144:
145: /***********************************************************************************************
146: Summarize and transfer may have been run : If all the records in psp_payroll_controls are
147: Summerized and transfered (status_code= 'P') then dont allow rollback and show error.
148: *********************************************************************************************** */
149: -- Bug 3950282:raise error only if all rows in Control table are already summerised and transfered.
150: IF l_all_sum_trans_flag = TRUE THEN