APPS.OTA_EL_ENROLL_SS dependencies on PER_ALL_PEOPLE_F

Line 95: FROM per_all_people_f pp

91: ,asg.internal_address_line work_line
92: ,asg.organization_id
93: ,loc.address_line_1 work_line1
94: ,loc.town_or_city work_city
95: FROM per_all_people_f pp
96: ,per_all_assignments_f asg
97: ,per_all_people_f p2
98: ,per_all_assignments_f asg2
99: -- ,per_addresses ad

Line 97: ,per_all_people_f p2

93: ,loc.address_line_1 work_line1
94: ,loc.town_or_city work_city
95: FROM per_all_people_f pp
96: ,per_all_assignments_f asg
97: ,per_all_people_f p2
98: ,per_all_assignments_f asg2
99: -- ,per_addresses ad
100: ,hr_locations loc
101: ,hr_all_organization_units org

Line 160: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

156: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
157: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
158: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
159: ,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
160: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
161: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
162: , p_message_name out nocopy varchar2
163: ,p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE
164: ,p_tdb_information_category in varchar2 default null

Line 360: FUNCTION Get_Person_To_Enroll_Details (p_person_id per_all_people_f.PERSON_ID%TYPE)

356: --
357: -- {End Of Comments}
358: -- ----------------------------------------------------------------------------
359:
360: FUNCTION Get_Person_To_Enroll_Details (p_person_id per_all_people_f.PERSON_ID%TYPE)
361: RETURN csr_person_to_enroll_details%ROWTYPE;
362:
363:
364: --

Line 394: PROCEDURE Validate_enrollment(p_person_id IN per_all_people_f.PERSON_ID%TYPE,

390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393:
394: PROCEDURE Validate_enrollment(p_person_id IN per_all_people_f.PERSON_ID%TYPE,
395: p_event_id IN VARCHAR2,
396: p_double_book OUT NOCOPY VARCHAR2);
397:
398: -- |--------------------------------------------------------------------------|