APPS.OTA_EL_ENROLL_SS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 84: HR_ALL_ORGANIZATION_UNITS hao

80: evt.activity_version_id,
81: evt.offering_id
82: FROM OTA_EVENTS evt,
83: OTA_EVENTS_TL evttl,
84: HR_ALL_ORGANIZATION_UNITS hao
85: WHERE evt.event_id = pp_event_id
86: AND evt.event_id = evttl.event_id
87: AND evt.organization_id = hao.organization_id (+)
88: AND evttl.language(+) = userenv('LANG'); -- Bug 2213009

Line 170: l_business_group_id_to hr_all_organization_units.organization_id%type;

166: l_maximum_internal_allowed NUMBER;
167:
168: l_item_key wf_items.item_key%type;
169: l_called_from varchar2(80);
170: l_business_group_id_to hr_all_organization_units.organization_id%type;
171: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
172: l_event_currency_code ota_events.currency_code%type;
173: l_event_title ota_events.title%type;
174: l_course_start_date ota_events.course_start_date%type;

Line 171: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

167:
168: l_item_key wf_items.item_key%type;
169: l_called_from varchar2(80);
170: l_business_group_id_to hr_all_organization_units.organization_id%type;
171: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
172: l_event_currency_code ota_events.currency_code%type;
173: l_event_title ota_events.title%type;
174: l_course_start_date ota_events.course_start_date%type;
175: l_course_end_date ota_events.course_end_date%type;