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 143: l_business_group_id_to hr_all_organization_units.organization_id%type;

139: ) is
140:
141: l_auto_create_finance varchar2(40);
142: l_price_basis ota_events.price_basis%type;
143: l_business_group_id_to hr_all_organization_units.organization_id%type;
144: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
145: l_event_currency_code ota_events.currency_code%type;
146: l_event_title ota_events.title%type;
147: l_course_start_date ota_events.course_start_date%type;

Line 144: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

140:
141: l_auto_create_finance varchar2(40);
142: l_price_basis ota_events.price_basis%type;
143: l_business_group_id_to hr_all_organization_units.organization_id%type;
144: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
145: l_event_currency_code ota_events.currency_code%type;
146: l_event_title ota_events.title%type;
147: l_course_start_date ota_events.course_start_date%type;
148: l_course_end_date ota_events.course_end_date%type;

Line 176: HR_ALL_ORGANIZATION_UNITS hao

172: evt.offering_id,
173: nvl(evt.price_basis,NULL)
174: FROM OTA_EVENTS_VL evt,
175: OTA_OFFERINGS off,
176: HR_ALL_ORGANIZATION_UNITS hao
177: WHERE evt.event_id = p_event_id
178: AND off.offering_id = evt.parent_offering_id
179: AND evt.organization_id = hao.organization_id (+);
180: