APPS.PER_EVENTS_PKG dependencies on PER_ALL_PEOPLE_F

Line 279: from per_all_people_f

275: where interview.event_id = p_event_id;
276: --
277: /*cursor csr_person_start (p_person_id in number) is
278: select min (effective_start_date)
279: from per_all_people_f
280: where person_id = p_person_id;
281: --
282: cursor csr_person_end (p_person_id in number) is
283: select max (effective_start_date)

Line 284: from per_all_people_f

280: where person_id = p_person_id;
281: --
282: cursor csr_person_end (p_person_id in number) is
283: select max (effective_start_date)
284: from per_all_people_f
285: where person_id = p_person_id;
286: --
287: --
288: interviewer_start date;

Line 648: select max(party_id) from per_all_people_f

644: where l.location_id = X_Location_Id
645: and nvl(l.inactive_date,X_ctl_globals_end_of_time) >= X_date_start;
646:
647: cursor csr_get_party_id is
648: select max(party_id) from per_all_people_f
649: where person_id = (select asg.person_id
650: from per_all_assignments_f asg
651: where asg.assignment_id = X_Assignment_Id
652: and X_Date_Start between asg.effective_start_date

Line 691: -- Get party_id from per_all_people_f using assignment_id

687: OPEN C2;
688: FETCH C2 INTO X_Event_Id;
689: CLOSE C2;
690: --
691: -- Get party_id from per_all_people_f using assignment_id
692: --
693: open csr_get_party_id;
694: fetch csr_get_party_id into l_party_id;
695: close csr_get_party_id;