eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_EL_ENROLL_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 96: ,per_all_assignments_f asg

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
100: ,hr_locations loc

Line 98: ,per_all_assignments_f asg2

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
102: WHERE pp.person_id = p_person_id

Line 155: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE

151: PROCEDURE ProcessSaveEnrollment( p_event_id IN VARCHAR2
152: ,p_extra_information IN VARCHAR2 DEFAULT NULL
153: ,p_mode IN VARCHAR2
154: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
155: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_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

Line 156: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE

152: ,p_extra_information IN VARCHAR2 DEFAULT NULL
153: ,p_mode IN VARCHAR2
154: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
155: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_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

Line 158: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE

154: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
155: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_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