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_DELEGATE_BOOKING_API dependencies on HR_ALL_ORGANIZATION_UNITS

Line 154: l_business_group_id_to hr_all_organization_units.organization_id%type;

150: ) is
151:
152: l_auto_create_finance varchar2(40);
153: l_price_basis ota_events.price_basis%type;
154: l_business_group_id_to hr_all_organization_units.organization_id%type;
155: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
156: l_event_currency_code ota_events.currency_code%type;
157: l_event_title ota_events.title%type;
158: l_course_start_date ota_events.course_start_date%type;

Line 155: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

151:
152: l_auto_create_finance varchar2(40);
153: l_price_basis ota_events.price_basis%type;
154: l_business_group_id_to hr_all_organization_units.organization_id%type;
155: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
156: l_event_currency_code ota_events.currency_code%type;
157: l_event_title ota_events.title%type;
158: l_course_start_date ota_events.course_start_date%type;
159: l_course_end_date ota_events.course_end_date%type;

Line 188: HR_ALL_ORGANIZATION_UNITS hao

184: evt.offering_id,
185: nvl(evt.price_basis,NULL)
186: FROM OTA_EVENTS_VL evt,
187: OTA_OFFERINGS off,
188: HR_ALL_ORGANIZATION_UNITS hao
189: WHERE evt.event_id = p_event_id
190: AND off.offering_id = evt.parent_offering_id
191: AND evt.organization_id = hao.organization_id (+);
192: