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_ENROLL_IN_TRAINING_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 98: ,per_all_assignments_f asg

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

Line 100: ,per_all_assignments_f asg2

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

Line 157: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE

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

Line 158: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE

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

Line 160: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE

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