APPS.PO_HR_LOCATION dependencies on FND_TERRITORIES

Line 96: , fnd_territories fte

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
100: , fnd_lookup_values flv3

Line 97: , fnd_territories_tl ftel

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
100: , fnd_lookup_values flv3
101: , fnd_lookup_values flv4

Line 189: , fnd_territories fte

185: , x_postal_code
186: , x_territory_short_name
187: , x_iso_territory_code
188: FROM hz_locations hzl
189: , fnd_territories fte
190: , fnd_territories_tl ftel
191: , fnd_lookup_values flv1
192: , fnd_lookup_values flv2
193: , fnd_lookup_values flv3

Line 190: , fnd_territories_tl ftel

186: , x_territory_short_name
187: , x_iso_territory_code
188: FROM hz_locations hzl
189: , fnd_territories fte
190: , fnd_territories_tl ftel
191: , fnd_lookup_values flv1
192: , fnd_lookup_values flv2
193: , fnd_lookup_values flv3
194: WHERE hzl.location_id = p_location_id

Line 302: l_iso_territory_code FND_TERRITORIES.iso_territory_code%TYPE;

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:
306: get_address (

Line 405: FND_TERRITORIES_TL FTE,

401: x_contact_phone,
402: x_contact_fax
403: FROM
404: HR_LOCATIONS HLC,
405: FND_TERRITORIES_TL FTE,
406: FND_LOOKUP_VALUES FCL1,
407: FND_LOOKUP_VALUES FCL2,
408: FND_LOOKUP_VALUES FCL3,
409: FND_LOOKUP_VALUES FCL4

Line 504: FND_TERRITORIES_TL FTE,

500: x_territory_short_name,
501: x_address_line_4
502: FROM
503: HZ_LOCATIONS HLC,
504: FND_TERRITORIES_TL FTE,
505: FND_LOOKUP_VALUES FCL1,
506: FND_LOOKUP_VALUES FCL2,
507: FND_LOOKUP_VALUES FCL3
508: WHERE

Line 750: FND_TERRITORIES_TL FTE,

746: x_contact_phone,
747: x_contact_fax
748: FROM
749: HR_LOCATIONS HLC,
750: FND_TERRITORIES_TL FTE,
751: FND_LOOKUP_VALUES FCL1,
752: FND_LOOKUP_VALUES FCL2,
753: FND_LOOKUP_VALUES FCL3,
754: FND_LOOKUP_VALUES FCL4

Line 1030: FND_TERRITORIES_TL FTE,

1026: x_address_line_4,
1027: l_style_code
1028: FROM
1029: HZ_LOCATIONS HLC,
1030: FND_TERRITORIES_TL FTE,
1031: FND_LOOKUP_VALUES FCL1,
1032: FND_LOOKUP_VALUES FCL2,
1033: FND_LOOKUP_VALUES FCL3
1034: WHERE