APPS.PAY_SIMULATOR_SS_PKG dependencies on HR_ASSIGNMENT_SETS

Line 187: SELECT hr_assignment_sets_s.nextval

183: , p_payroll_id IN number) RETURN number IS
184: l_assignment_set_id number;
185: l_assignment_set_name varchar2(240);
186: BEGIN
187: SELECT hr_assignment_sets_s.nextval
188: INTO l_assignment_set_id
189: FROM sys.dual;
190:
191: l_assignment_set_name := 'Simulation'

Line 196: INTO hr_assignment_sets (assignment_set_id

192: || l_assignment_set_id
193: || p_payroll_id;
194:
195: INSERT
196: INTO hr_assignment_sets (assignment_set_id
197: , business_group_id
198: , payroll_id
199: , assignment_set_name)
200: VALUES (l_assignment_set_id

Line 414: delete from hr_assignment_sets where assignment_set_id = l_assignment_set_id;

410: if get_payroll_action_id%found then
411: py_rollback_pkg.rollback_payroll_action(p_payroll_action_id=>l_payroll_action_id);
412:
413: delete from hr_assignment_set_amendments where assignment_set_id = l_assignment_set_id;
414: delete from hr_assignment_sets where assignment_set_id = l_assignment_set_id;
415:
416: COMMIT;
417: end if;
418: close get_payroll_action_id;