APPS.OTA_GENERAL dependencies on HR_LOCATIONS

Line 1085: l_location_code hr_locations.location_code%type;

1081:
1082: function get_location (p_location_id in number)
1083: return varchar2 IS
1084:
1085: l_location_code hr_locations.location_code%type;
1086:
1087: CURSOR c_get_location IS
1088: SELECT loc.location_code
1089: FROM hr_locations_all loc

Line 1089: FROM hr_locations_all loc

1085: l_location_code hr_locations.location_code%type;
1086:
1087: CURSOR c_get_location IS
1088: SELECT loc.location_code
1089: FROM hr_locations_all loc
1090: WHERE loc.Location_id = p_location_id;
1091:
1092: BEGIN
1093: For a in c_get_location

Line 1137: FROM hr_locations_all_tl loc

1133: IS
1134: --
1135: CURSOR loc_country_cr IS
1136: SELECT loc.location_code
1137: FROM hr_locations_all_tl loc
1138: WHERE loc.location_id = p_location_id
1139: AND loc.language = USERENV('LANG');
1140:
1141: --

Line 1142: l_loc_code hr_locations_all.location_code%TYPE := null;

1138: WHERE loc.location_id = p_location_id
1139: AND loc.language = USERENV('LANG');
1140:
1141: --
1142: l_loc_code hr_locations_all.location_code%TYPE := null;
1143: --
1144: BEGIN
1145: --
1146: --