APPS.OTA_ENROLL_IN_TRAINING_SS dependencies on PER_ALL_PEOPLE_F

Line 97: FROM per_all_people_f pp

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

Line 99: ,per_all_people_f p2

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

Line 162: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

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

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

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

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

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