APPS.OTA_INITIALIZATION_WF dependencies on HR_LOCATIONS_ALL_TL

Line 698: l_location_name hr_locations_all_tl.location_code%type;

694:
695: l_person_id per_people_f.person_id%type;
696:
697: l_object_type varchar2(240);
698: l_location_name hr_locations_all_tl.location_code%type;
699: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
700: l_timezone varchar2(300);
701:
702:

Line 960: l_location_name hr_locations_all_tl.location_code%type;

956: l_location_id ota_events.location_id %type;
957: l_event_type ota_events.event_type%type;
958:
959: --l_object_type varchar2(240);
960: l_location_name hr_locations_all_tl.location_code%type;
961: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
962:
963: l_booking_id ota_delegate_bookings.booking_id%type;
964: l_person_id number(15);

Line 2058: l_location_name hr_locations_all_tl.location_code%type;

2054: l_location_id ota_events.location_id %type;
2055: l_training_center_id ota_events.training_center_id %type;
2056: l_event_type ota_events.event_type%type;
2057:
2058: l_location_name hr_locations_all_tl.location_code%type;
2059: l_training_center hr_all_organization_units.name%TYPE;
2060: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
2061:
2062: l_booking_id ota_delegate_bookings.booking_id%type;