DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_LOCATIONS

Line 514: FROM HZ_LOCATIONS LOC,

510:
511: -- Populate data into tax assignment table.
512:
513: SELECT LOC.LOCATION_ID INTO l_location_id
514: FROM HZ_LOCATIONS LOC,
515: HZ_PARTY_SITES PARTY_SITE,
516: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
517: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
518: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 938: FROM HZ_LOCATIONS LOC,

934:
935: -- Update location should populate the change to tax assignment.
936: -- Bug Fix : 2230802.
937: SELECT LOC.LOCATION_ID INTO l_location_id
938: FROM HZ_LOCATIONS LOC,
939: HZ_PARTY_SITES PARTY_SITE,
940: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
941: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
942: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID