APPS.HR_PERSON_INTERNAL dependencies on PER_EVENTS

Line 888: from per_events e

884: into l_delete_permitted
885: from sys.dual
886: where not exists (
887: select null
888: from per_events e
889: where e.internal_contact_person_id = P_PERSON_ID);
890: --
891: exception
892: when NO_DATA_FOUND then

Line 1254: from per_events e

1250: into l_delete_permitted
1251: from sys.dual
1252: where not exists (
1253: select null
1254: from per_events e
1255: where exists (
1256: select null
1257: from per_assignments_f a
1258: where a.person_id = P_PERSON_ID

Line 2986: from per_events e

2982: forall i in 1..l_assignment_id.count
2983: delete from per_bookings b
2984: where b.event_id in
2985: (select e.event_id
2986: from per_events e
2987: where e.assignment_id = l_assignment_id(i));
2988:
2989: /*delete from per_bookings b
2990: where b.event_id in

Line 2992: from per_events e

2988:
2989: /*delete from per_bookings b
2990: where b.event_id in
2991: (select e.event_id
2992: from per_events e
2993: where exists (
2994: select null
2995: from per_assignments_f ass
2996: where ass.assignment_id = e.assignment_id

Line 3015: delete from per_events e

3011: -- bug fix 3732129.
3012: -- Delete statement modified to improve performance.
3013: --
3014: forall i in 1..l_assignment_id.count
3015: delete from per_events e
3016: where e.assignment_id = l_assignment_id(i);
3017:
3018: /* delete from per_events e
3019: where e.assignment_id in (

Line 3018: /* delete from per_events e

3014: forall i in 1..l_assignment_id.count
3015: delete from per_events e
3016: where e.assignment_id = l_assignment_id(i);
3017:
3018: /* delete from per_events e
3019: where e.assignment_id in (
3020: select ass.assignment_id
3021: from per_assignments_f ass
3022: where ass.person_id = P_PERSON_ID);*/

Line 3036: update per_events e

3032: end if;
3033: --
3034: begin
3035: --
3036: update per_events e
3037: set e.internal_contact_person_id = null
3038: where e.internal_contact_person_id = P_PERSON_ID;
3039: --
3040: exception