APPS.PO_HR_LOCATION dependencies on HR_LOCATIONS_ALL

Line 94: FROM hr_locations_all hrl

90: , x_state_or_province
91: , x_postal_code
92: , x_territory_short_name
93: , x_iso_territory_code
94: FROM hr_locations_all hrl
95: , fnd_territories fte
96: , fnd_territories_tl ftel
97: , fnd_lookup_values flv1
98: , fnd_lookup_values flv2

Line 288: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;

284: Address_line_3 OUT NOCOPY Varchar2,
285: Territory_short_name OUT NOCOPY VArchar2,
286: Address_info OUT NOCOPY Varchar2 )
287: IS
288: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;
289: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;
290: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
291: l_iso_territory_code FND_TERRITORIES.iso_territory_code%TYPE;
292:

Line 289: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;

285: Territory_short_name OUT NOCOPY VArchar2,
286: Address_info OUT NOCOPY Varchar2 )
287: IS
288: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;
289: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;
290: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
291: l_iso_territory_code FND_TERRITORIES.iso_territory_code%TYPE;
292:
293: Begin

Line 290: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

286: Address_info OUT NOCOPY Varchar2 )
287: IS
288: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;
289: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;
290: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
291: l_iso_territory_code FND_TERRITORIES.iso_territory_code%TYPE;
292:
293: Begin
294: