DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_QUICKPAINT_RESULT_TEXT

Line 1104: from per_quickpaint_result_text t

1100: into v_delete_permitted
1101: from sys.dual
1102: where not exists (
1103: select null
1104: from per_quickpaint_result_text t
1105: where exists (
1106: select null
1107: from per_assignments_f a
1108: where a.person_id = P_PERSON_ID

Line 2349: delete from per_quickpaint_result_text q

2345: --
2346: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 29);
2347: --
2348: begin
2349: delete from per_quickpaint_result_text q
2350: where q.assignment_id in (
2351: select ass.assignment_id
2352: from per_assignments_f ass
2353: where ass.person_id = P_PERSON_ID);