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 3200: -- pay_assignment_actions in weak_predel_validation.

3196: hr_utility.set_location(l_proc, 890);
3197: end if;
3198: --
3199: -- Validation has already been performed against
3200: -- pay_assignment_actions in weak_predel_validation.
3201: --
3202: begin
3203: --
3204: delete from pay_assignment_actions a

Line 3204: delete from pay_assignment_actions a

3200: -- pay_assignment_actions in weak_predel_validation.
3201: --
3202: begin
3203: --
3204: delete from pay_assignment_actions a
3205: where a.assignment_id in
3206: (select ass.assignment_id
3207: from per_assignments_f ass
3208: where ass.person_id = P_PERSON_ID);