DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PER_REQUISITIONS

Line 1113: from per_requisitions r

1109: into l_delete_permitted
1110: from sys.dual
1111: where not exists (
1112: select null
1113: from per_requisitions r
1114: where r.person_id = P_PERSON_ID);
1115: --
1116: exception
1117: when NO_DATA_FOUND then

Line 2082: update per_requisitions r

2078: end if;
2079: --
2080: begin
2081: --
2082: update per_requisitions r
2083: set r.person_id = null
2084: where r.person_id = P_PERSON_ID;
2085: --
2086: exception