DBA Data[Home] [Help]

APPS.HZ_ACCOUNT_MERGE_PUB dependencies on HZ_LOCATIONS

Line 1395: FROM hz_locations loc,

1391: , LOC.STATE
1392: , LOC.PROVINCE
1393: , LOC.POSTAL_CODE
1394: , TERR.TERRITORY_SHORT_NAME ),1,240) INTO l_from_address
1395: FROM hz_locations loc,
1396: FND_TERRITORIES_VL TERR
1397: WHERE loc.location_id = l_from_location_id
1398: and LOC.COUNTRY = TERR.TERRITORY_CODE (+);
1399:

Line 1411: FROM hz_locations loc,

1407: , LOC.STATE
1408: , LOC.PROVINCE
1409: , LOC.POSTAL_CODE
1410: , TERR.TERRITORY_SHORT_NAME ),1,240) INTO l_to_address
1411: FROM hz_locations loc,
1412: FND_TERRITORIES_VL TERR
1413: WHERE loc.location_id = l_to_location_id
1414: and LOC.COUNTRY = TERR.TERRITORY_CODE (+);
1415: