DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 315: from pay_assignment_actions paa,

311: into v_delete_permitted
312: from sys.dual
313: where not exists (
314: select null
315: from pay_assignment_actions paa,
316: per_assignments_f ass,
317: pay_payroll_actions ppa
318: where paa.assignment_id = ass.assignment_id
319: and ass.person_id = P_PERSON_ID

Line 2333: -- pay_assignment_actions in weak_predel_validation.

2329: --
2330: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 33);
2331: --
2332: -- Validation has already been performed against
2333: -- pay_assignment_actions in weak_predel_validation.
2334: --
2335: begin
2336: delete from pay_assignment_actions a
2337: where exists (

Line 2336: delete from pay_assignment_actions a

2332: -- Validation has already been performed against
2333: -- pay_assignment_actions in weak_predel_validation.
2334: --
2335: begin
2336: delete from pay_assignment_actions a
2337: where exists (
2338: select null
2339: from per_assignments_f ass
2340: where ass.person_id = P_PERSON_ID