APPS.PO_HR_LOCATION dependencies on HR_LOCATIONS_ALL

Line 95: FROM hr_locations_all hrl

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

Line 299: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;

295: Address_line_3 OUT NOCOPY Varchar2,
296: Territory_short_name OUT NOCOPY VArchar2,
297: Address_info OUT NOCOPY Varchar2 )
298: IS
299: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;
300: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;
301: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
302: l_iso_territory_code FND_TERRITORIES.iso_territory_code%TYPE;
303:

Line 300: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;

296: Territory_short_name OUT NOCOPY VArchar2,
297: Address_info OUT NOCOPY Varchar2 )
298: IS
299: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;
300: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;
301: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
302: l_iso_territory_code FND_TERRITORIES.iso_territory_code%TYPE;
303:
304: Begin

Line 301: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

297: Address_info OUT NOCOPY Varchar2 )
298: IS
299: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;
300: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;
301: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
302: l_iso_territory_code FND_TERRITORIES.iso_territory_code%TYPE;
303:
304: Begin
305: