APPS.PSP_ADJ_DRIVER dependencies on PSP_PAYROLL_CONTROLS_S

Line 2267: update psp_payroll_controls set status_code = 'N'

2263: approval_date = SYSDATE -- Added to fix bug 1661405. approval_date is a new column added to the table
2264: where adjustment_batch_name = p_batch_name;
2265:
2266: --Modified by Rashmi to update psp_payroll_control table.
2267: update psp_payroll_controls set status_code = 'N'
2268: where batch_name = p_batch_name and source_type = 'A'
2269: and status_code = 'C';
2270:
2271: commit;

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

2478: close get_payroll_id;
2479:
2480: --Modified the code by Rashmi to assign status = 'C' (for Creation).
2481:
2482: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
2483: insert into psp_payroll_controls(
2484: payroll_control_id,
2485: payroll_action_id,
2486: payroll_source_code,

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

3117: counter := 1;
3118:
3119: l_struc_num := psp_general.find_chart_of_accts(p_set_of_books_id,l_chart_of_accts);
3120:
3121: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
3122:
3123: hr_utility.trace('l_payroll_control_id = '||l_payroll_control_id);
3124: hr_utility.trace('Inserting into PSP_ADJUSTMENT_CONTROL_TABLE : batch = '||p_batch_name);
3125: