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

Line 85: HR_ALL_ORGANIZATION_UNITS hao

81: off.activity_version_id,
82: evt.offering_id
83: FROM OTA_EVENTS_VL evt,
84: OTA_OFFERINGS off,
85: HR_ALL_ORGANIZATION_UNITS hao
86: WHERE evt.event_id = pp_event_id
87: AND off.offering_id = evt.parent_offering_id
88: AND evt.organization_id = hao.organization_id (+);
89:

Line 183: l_business_group_id_to hr_all_organization_units.organization_id%type;

179: l_existing_internal NUMBER;
180: l_maximum_internal_allowed NUMBER;
181:
182: l_called_from varchar2(80);
183: l_business_group_id_to hr_all_organization_units.organization_id%type;
184: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
185: l_event_currency_code ota_events.currency_code%type;
186: l_event_title ota_events.title%type;
187: l_course_start_date ota_events.course_start_date%type;

Line 184: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

180: l_maximum_internal_allowed NUMBER;
181:
182: l_called_from varchar2(80);
183: l_business_group_id_to hr_all_organization_units.organization_id%type;
184: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
185: l_event_currency_code ota_events.currency_code%type;
186: l_event_title ota_events.title%type;
187: l_course_start_date ota_events.course_start_date%type;
188: l_course_end_date ota_events.course_end_date%type;