APPS.PSP_ROLLBACK_DIST_LINES dependencies on PSP_PAYROLL_CONTROLS

Line 16: from psp_payroll_controls

12: p_set_of_books_id IN NUMBER) IS
13:
14: CURSOR payroll_control_cur IS -- Bug 6686483
15: select payroll_control_id,status_code,time_period_id
16: from psp_payroll_controls
17: where business_group_id = p_business_group_id
18: AND set_of_books_id = p_set_of_books_id
19: AND source_type = nvl(p_source_type,source_type)
20: AND source_type <> 'A' -- Bug 7136917

Line 28: from psp_payroll_controls ppc1

24: AND nvl(batch_name,'N') = nvl(nvl(p_batch_name,batch_name),'N')
25: AND parent_payroll_control_id IS NULL
26: UNION
27: select payroll_control_id,status_code,time_period_id
28: from psp_payroll_controls ppc1
29: where ppc1.parent_payroll_control_id in(select payroll_control_id
30: from psp_payroll_controls
31: where business_group_id = p_business_group_id
32: AND set_of_books_id = p_set_of_books_id

Line 30: from psp_payroll_controls

26: UNION
27: select payroll_control_id,status_code,time_period_id
28: from psp_payroll_controls ppc1
29: where ppc1.parent_payroll_control_id in(select payroll_control_id
30: from psp_payroll_controls
31: where business_group_id = p_business_group_id
32: AND set_of_books_id = p_set_of_books_id
33: AND source_type = nvl(p_source_type,source_type)
34: AND source_type <> 'A' -- Bug 7136917

Line 96: UPDATE PSP_PAYROLL_CONTROLS

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,
99: cdl_payroll_action_id = NULL --- salary cap 4304623
100: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;