APPS.PSP_ADJ_DRIVER dependencies on PSP_PAYROLL_CONTROLS_S

Line 2276: update psp_payroll_controls set status_code = 'N'

2272: approval_date = SYSDATE -- Added to fix bug 1661405. approval_date is a new column added to the table
2273: where adjustment_batch_name = p_batch_name;
2274:
2275: --Modified by Rashmi to update psp_payroll_control table.
2276: update psp_payroll_controls set status_code = 'N'
2277: where batch_name = p_batch_name and source_type = 'A'
2278: and status_code = 'C';
2279:
2280: commit;

Line 2491: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;

2487: close get_payroll_id;
2488:
2489: --Modified the code by Rashmi to assign status = 'C' (for Creation).
2490:
2491: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
2492: insert into psp_payroll_controls(
2493: payroll_control_id,
2494: payroll_action_id,
2495: payroll_source_code,

Line 3130: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;

3126: counter := 1;
3127:
3128: l_struc_num := psp_general.find_chart_of_accts(p_set_of_books_id,l_chart_of_accts);
3129:
3130: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
3131:
3132: hr_utility.trace('l_payroll_control_id = '||l_payroll_control_id);
3133: hr_utility.trace('Inserting into PSP_ADJUSTMENT_CONTROL_TABLE : batch = '||p_batch_name);
3134: