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

Line 95: ,per_all_assignments_f asg

91: ,asg.organization_id
92: ,loc.address_line_1 work_line1
93: ,loc.town_or_city work_city
94: FROM per_all_people_f pp
95: ,per_all_assignments_f asg
96: ,per_all_people_f p2
97: ,per_all_assignments_f asg2
98: -- ,per_addresses ad
99: ,hr_locations loc

Line 97: ,per_all_assignments_f asg2

93: ,loc.town_or_city work_city
94: FROM per_all_people_f pp
95: ,per_all_assignments_f asg
96: ,per_all_people_f p2
97: ,per_all_assignments_f asg2
98: -- ,per_addresses ad
99: ,hr_locations loc
100: ,hr_all_organization_units org
101: WHERE pp.person_id = p_person_id

Line 154: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE

150: PROCEDURE ProcessSaveEnrollment( p_event_id IN VARCHAR2
151: ,p_extra_information IN VARCHAR2 DEFAULT NULL
152: ,p_mode IN VARCHAR2
153: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
154: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
155: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
156: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
157: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
158: --,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE

Line 155: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE

151: ,p_extra_information IN VARCHAR2 DEFAULT NULL
152: ,p_mode IN VARCHAR2
153: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
154: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
155: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
156: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
157: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
158: --,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
159: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

Line 157: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE

153: ,p_cost_centers IN VARCHAR2 DEFAULT NULL
154: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
155: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
156: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
157: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
158: --,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
159: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
160: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
161: , p_message_name out nocopy varchar2