DBA Data[Home] [Help]

APPS.OTA_TDB_BUS2 dependencies on HZ_LOCATIONS

Line 509: from HZ_LOCATIONS loc,

505: -- Bug#2652833 arkashya replaced cursor query to use HZ_ tables directly instead of ra_ views
506:
507: cursor l_address is
508: select 1
509: from HZ_LOCATIONS loc,
510: HZ_CUST_ACCT_SITES acct_site,
511: HZ_PARTY_SITES party_site
512: where PARTY_SITE.location_id = LOC.location_id
513: and ACCT_SITE.party_site_id = PARTY_SITE.party_site_id