DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 316: from pay_assignment_actions paa,

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

Line 2404: -- pay_assignment_actions in weak_predel_validation.

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 (

Line 2407: delete from pay_assignment_actions a

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