DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_SS_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 206: INTO hr_assignment_set_amendments (assignment_id

202: , p_payroll_id
203: , l_assignment_set_name);
204:
205: INSERT
206: INTO hr_assignment_set_amendments (assignment_id
207: , assignment_set_id
208: , include_or_exclude)
209: VALUES (p_assignment_id
210: , l_assignment_set_id

Line 413: delete from hr_assignment_set_amendments where assignment_set_id = l_assignment_set_id;

409: fetch get_payroll_action_id into l_payroll_action_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;