DBA Data[Home] [Help]

APPS.PO_HR_LOCATION dependencies on FND_TERRITORIES_TL

Line 96: , fnd_territories_tl ftel

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
99: , fnd_lookup_values flv3
100: WHERE hrl.location_id = p_location_id

Line 179: , fnd_territories_tl ftel

175: , x_territory_short_name
176: , x_iso_territory_code
177: FROM hz_locations hzl
178: , fnd_territories fte
179: , fnd_territories_tl ftel
180: , fnd_lookup_values flv1
181: , fnd_lookup_values flv2
182: , fnd_lookup_values flv3
183: WHERE hzl.location_id = p_location_id

Line 393: FND_TERRITORIES_TL FTE,

389: x_contact_phone,
390: x_contact_fax
391: FROM
392: HR_LOCATIONS HLC,
393: FND_TERRITORIES_TL FTE,
394: FND_LOOKUP_VALUES FCL1,
395: FND_LOOKUP_VALUES FCL2,
396: FND_LOOKUP_VALUES FCL3
397: Where

Line 482: FND_TERRITORIES_TL FTE,

478: x_territory_short_name,
479: x_address_line_4
480: FROM
481: HZ_LOCATIONS HLC,
482: FND_TERRITORIES_TL FTE,
483: FND_LOOKUP_VALUES FCL1,
484: FND_LOOKUP_VALUES FCL2,
485: FND_LOOKUP_VALUES FCL3
486: WHERE

Line 727: FND_TERRITORIES_TL FTE,

723: x_contact_phone,
724: x_contact_fax
725: FROM
726: HR_LOCATIONS HLC,
727: FND_TERRITORIES_TL FTE,
728: FND_LOOKUP_VALUES FCL1,
729: FND_LOOKUP_VALUES FCL2,
730: FND_LOOKUP_VALUES FCL3
731: Where

Line 997: FND_TERRITORIES_TL FTE,

993: x_address_line_4,
994: l_style_code
995: FROM
996: HZ_LOCATIONS HLC,
997: FND_TERRITORIES_TL FTE,
998: FND_LOOKUP_VALUES FCL1,
999: FND_LOOKUP_VALUES FCL2,
1000: FND_LOOKUP_VALUES FCL3
1001: WHERE