DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_QUICKPAINT_RESULT_TEXT

Line 1103: from per_quickpaint_result_text t

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

Line 2278: delete from per_quickpaint_result_text q

2274: --
2275: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 29);
2276: --
2277: begin
2278: delete from per_quickpaint_result_text q
2279: where q.assignment_id in (
2280: select ass.assignment_id
2281: from per_assignments_f ass
2282: where ass.person_id = P_PERSON_ID);