DBA Data[Home] [Help]

APPS.PO_HR_LOCATION dependencies on FND_TERRITORIES_TL

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 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 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