APPS.OTA_BULK_ENROLL_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 429: HR_ALL_ORGANIZATION_UNITS hao

425: off.activity_version_id,
426: evt.offering_id
427: FROM OTA_EVENTS_VL evt,
428: OTA_OFFERINGS off,
429: HR_ALL_ORGANIZATION_UNITS hao
430: WHERE evt.event_id = pp_event_id
431: AND off.offering_id = evt.parent_offering_id
432: AND evt.organization_id = hao.organization_id (+);
433:

Line 592: l_business_group_id_to hr_all_organization_units.organization_id%type;

588: l_existing_internal NUMBER;
589: l_maximum_internal_allowed NUMBER;
590:
591: l_called_from VARCHAR2(80);
592: l_business_group_id_to hr_all_organization_units.organization_id%type;
593: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
594: l_event_currency_code ota_events.currency_code%type;
595: l_event_title ota_events.title%type;
596: l_course_start_date ota_events.course_start_date%type;

Line 593: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

589: l_maximum_internal_allowed NUMBER;
590:
591: l_called_from VARCHAR2(80);
592: l_business_group_id_to hr_all_organization_units.organization_id%type;
593: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
594: l_event_currency_code ota_events.currency_code%type;
595: l_event_title ota_events.title%type;
596: l_course_start_date ota_events.course_start_date%type;
597: l_course_end_date ota_events.course_end_date%type;