DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 175: from pay_assignment_actions paa

171: into l_delete_permitted
172: from sys.dual
173: where not exists
174: (select null
175: from pay_assignment_actions paa
176: ,per_assignments_f ass
177: ,pay_payroll_actions ppa
178: where paa.assignment_id = ass.assignment_id
179: and ass.person_id = P_PERSON_ID

Line 3147: -- pay_assignment_actions in weak_predel_validation.

3143: hr_utility.set_location(l_proc, 890);
3144: end if;
3145: --
3146: -- Validation has already been performed against
3147: -- pay_assignment_actions in weak_predel_validation.
3148: --
3149: begin
3150: --
3151: delete from pay_assignment_actions a

Line 3151: delete from pay_assignment_actions a

3147: -- pay_assignment_actions in weak_predel_validation.
3148: --
3149: begin
3150: --
3151: delete from pay_assignment_actions a
3152: where a.assignment_id in
3153: (select ass.assignment_id
3154: from per_assignments_f ass
3155: where ass.person_id = P_PERSON_ID);