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 2063: l_location_name hr_locations_all_tl.location_code%type;

2059: l_location_id ota_events.location_id %type;
2060: l_training_center_id ota_events.training_center_id %type;
2061: l_event_type ota_events.event_type%type;
2062:
2063: l_location_name hr_locations_all_tl.location_code%type;
2064: l_training_center hr_all_organization_units.name%TYPE;
2065: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
2066:
2067: l_booking_id ota_delegate_bookings.booking_id%type;