APPS.HR_PERSON_INTERNAL dependencies on PER_ABSENCE_ATTENDANCES

Line 1039: from per_absence_attendances a

1035: into l_delete_permitted
1036: from sys.dual
1037: where not exists (
1038: select null
1039: from per_absence_attendances a
1040: where a.person_id = P_PERSON_ID);
1041: --
1042: exception
1043: when NO_DATA_FOUND then

Line 1059: from per_absence_attendances a

1055: into l_delete_permitted
1056: from sys.dual
1057: where not exists (
1058: select null
1059: from per_absence_attendances a
1060: where a.authorising_person_id = P_PERSON_ID
1061: or a.replacement_person_id = P_PERSON_ID);
1062: --
1063: exception

Line 2156: delete from per_absence_attendances a

2152: end if;
2153: --
2154: begin
2155: --
2156: delete from per_absence_attendances a
2157: where a.person_id = P_PERSON_ID;
2158: --
2159: exception
2160: when NO_DATA_FOUND then

Line 2172: update per_absence_attendances a

2168: end if;
2169: --
2170: begin
2171: --
2172: update per_absence_attendances a
2173: set a.authorising_person_id = null
2174: where a.authorising_person_id = P_PERSON_ID;
2175: --
2176: exception

Line 2189: update per_absence_attendances a

2185: end if;
2186: --
2187: begin
2188: --
2189: update per_absence_attendances a
2190: set a.replacement_person_id = null
2191: where a.replacement_person_id = P_PERSON_ID;
2192: --
2193: exception