APPS.OTA_TRNG_ENROLL_SS dependencies on PER_ALL_PEOPLE_F

Line 94: FROM per_all_people_f pp

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

Line 96: ,per_all_people_f p2

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

Line 159: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

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

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

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

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

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