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 208: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE

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

Line 209: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE

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

Line 211: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE

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