499:
500: -- Populate data into tax assignment table.
501:
502: SELECT LOC.LOCATION_ID INTO l_location_id
503: FROM HZ_LOCATIONS LOC,
504: HZ_PARTY_SITES PARTY_SITE,
505: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
506: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
507: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
852:
853: -- Update location should populate the change to tax assignment.
854: -- Bug Fix : 2230802.
855: SELECT LOC.LOCATION_ID INTO l_location_id
856: FROM HZ_LOCATIONS LOC,
857: HZ_PARTY_SITES PARTY_SITE,
858: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
859: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
860: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID