312: into v_delete_permitted
313: from sys.dual
314: where not exists (
315: select null
316: from pay_assignment_actions paa,
317: per_assignments_f ass,
318: pay_payroll_actions ppa
319: where paa.assignment_id = ass.assignment_id
320: and ass.person_id = P_PERSON_ID
2400: --
2401: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 33);
2402: --
2403: -- Validation has already been performed against
2404: -- pay_assignment_actions in weak_predel_validation.
2405: --
2406: begin
2407: delete from pay_assignment_actions a
2408: where exists (
2403: -- Validation has already been performed against
2404: -- pay_assignment_actions in weak_predel_validation.
2405: --
2406: begin
2407: delete from pay_assignment_actions a
2408: where exists (
2409: select null
2410: from per_assignments_f ass
2411: where ass.person_id = P_PERSON_ID