APPS.HR_PERSON_INTERNAL dependencies on PER_EVENTS

Line 917: from per_events e

913: into l_delete_permitted
914: from sys.dual
915: where not exists (
916: select null
917: from per_events e
918: where e.internal_contact_person_id = P_PERSON_ID);
919: --
920: exception
921: when NO_DATA_FOUND then

Line 1283: from per_events e

1279: into l_delete_permitted
1280: from sys.dual
1281: where not exists (
1282: select null
1283: from per_events e
1284: where exists (
1285: select null
1286: from per_assignments_f a
1287: where a.person_id = P_PERSON_ID

Line 3039: from per_events e

3035: forall i in 1..l_assignment_id.count
3036: delete from per_bookings b
3037: where b.event_id in
3038: (select e.event_id
3039: from per_events e
3040: where e.assignment_id = l_assignment_id(i));
3041:
3042: /*delete from per_bookings b
3043: where b.event_id in

Line 3045: from per_events e

3041:
3042: /*delete from per_bookings b
3043: where b.event_id in
3044: (select e.event_id
3045: from per_events e
3046: where exists (
3047: select null
3048: from per_assignments_f ass
3049: where ass.assignment_id = e.assignment_id

Line 3068: delete from per_events e

3064: -- bug fix 3732129.
3065: -- Delete statement modified to improve performance.
3066: --
3067: forall i in 1..l_assignment_id.count
3068: delete from per_events e
3069: where e.assignment_id = l_assignment_id(i);
3070:
3071: /* delete from per_events e
3072: where e.assignment_id in (

Line 3071: /* delete from per_events e

3067: forall i in 1..l_assignment_id.count
3068: delete from per_events e
3069: where e.assignment_id = l_assignment_id(i);
3070:
3071: /* delete from per_events e
3072: where e.assignment_id in (
3073: select ass.assignment_id
3074: from per_assignments_f ass
3075: where ass.person_id = P_PERSON_ID);*/

Line 3089: update per_events e

3085: end if;
3086: --
3087: begin
3088: --
3089: update per_events e
3090: set e.internal_contact_person_id = null
3091: where e.internal_contact_person_id = P_PERSON_ID;
3092: --
3093: exception