DBA Data[Home] [Help]

APPS.OTA_LEARNER_ENROLL_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 103: ,per_all_assignments_f asg

99: ,loc.town_or_city work_city
100: ,pph.PHONE_NUMBER work_telephone
101: ,pfax.PHONE_NUMBER work_fax
102: FROM per_all_people_f pp
103: ,per_all_assignments_f asg
104: ,per_all_people_f p2
105: ,per_all_assignments_f asg2
106: ,per_person_types ppt
107: ,per_person_type_usages_f ptu

Line 105: ,per_all_assignments_f asg2

101: ,pfax.PHONE_NUMBER work_fax
102: FROM per_all_people_f pp
103: ,per_all_assignments_f asg
104: ,per_all_people_f p2
105: ,per_all_assignments_f asg2
106: ,per_person_types ppt
107: ,per_person_type_usages_f ptu
108: -- ,per_addresses ad
109: ,hr_locations_all loc

Line 209: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE

205: PROCEDURE ProcessSaveEnrollment( p_event_id IN VARCHAR2
206: ,p_extra_information IN VARCHAR2 DEFAULT NULL
207: ,p_mode IN VARCHAR2
208: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
209: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
210: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
211: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
212: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
213: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

Line 210: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE

206: ,p_extra_information IN VARCHAR2 DEFAULT NULL
207: ,p_mode IN VARCHAR2
208: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
209: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
210: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
211: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
212: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
213: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
214: ,p_delegate_contact_id IN NUMBER

Line 212: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE

208: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
209: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
210: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
211: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
212: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
213: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
214: ,p_delegate_contact_id IN NUMBER
215: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
216: , p_message_name out nocopy varchar2