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

Line 983: l_business_group_id_to hr_all_organization_units.organization_id%type;

979: l_cancel_boolean BOOLEAN;
980: l_auto_create_finance VARCHAR2(40);
981: l_price_basis OTA_EVENTS.price_basis%TYPE;
982: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
983: l_business_group_id_to hr_all_organization_units.organization_id%type;
984: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
985: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
986: l_user NUMBER;
987: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

Line 992: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

988: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
989: fapi_result VARCHAR2(40);
990: fapi_from VARCHAR2(5);
991: fapi_to VARCHAR2(5);
992: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
993: l_event_currency_code ota_events.currency_code%type;
994: l_event_status ota_events.event_status%type;
995: l_cost_allocation_keyflex_id VARCHAR2(1000);
996: l_maximum_internal_attendees NUMBER;

Line 1076: HR_ALL_ORGANIZATION_UNITS hao

1072: evt.course_end_time
1073: FROM OTA_EVENTS_VL evt,
1074: OTA_OFFERINGS ofr,
1075: OTA_CATEGORY_USAGES_TL ctl,
1076: HR_ALL_ORGANIZATION_UNITS hao
1077: WHERE evt.event_id = l_eventid
1078: AND evt.parent_offering_id = ofr.offering_id
1079: AND evt.organization_id = hao.organization_id (+)
1080: AND ctl.Category_usage_id = ofr.delivery_mode_id