APPS.OTA_ENROLL_IN_TRAINING_SS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 83: HR_ALL_ORGANIZATION_UNITS hao

79: evt.owner_id,
80: evt.activity_version_id,
81: evt.offering_id
82: FROM OTA_EVENTS_VL evt,
83: HR_ALL_ORGANIZATION_UNITS hao
84: WHERE evt.event_id = pp_event_id
85: AND evt.organization_id = hao.organization_id (+); -- Bug 2213009
86:
87:

Line 169: l_business_group_id_to hr_all_organization_units.organization_id%type;

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

Line 170: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

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