DBA Data[Home] [Help]

APPS.HZ_ACCOUNT_MERGE_PUB dependencies on ARP_ADDR_PKG

Line 1384: select substr(ARP_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE

1380:
1381: l_from_location_id := g_location_id(l_account_merge_request_obj.site_merge_details(i).merge_from_account_site_obj.account_site_id);
1382: l_to_location_id := g_location_id(l_account_merge_request_obj.site_merge_details(i).merge_to_account_site_obj.account_site_id);
1383:
1384: select substr(ARP_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE
1385: , LOC.ADDRESS1
1386: , LOC.ADDRESS2
1387: , LOC.ADDRESS3
1388: , LOC.ADDRESS4

Line 1400: select substr(ARP_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE

1396: FND_TERRITORIES_VL TERR
1397: WHERE loc.location_id = l_from_location_id
1398: and LOC.COUNTRY = TERR.TERRITORY_CODE (+);
1399:
1400: select substr(ARP_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE
1401: , LOC.ADDRESS1
1402: , LOC.ADDRESS2
1403: , LOC.ADDRESS3
1404: , LOC.ADDRESS4