DBA Data[Home] [Help]

APPS.OTA_TDB_BUS2 dependencies on HZ_CUST_ACCT_SITES

Line 510: HZ_CUST_ACCT_SITES acct_site,

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
514: and ACCT_SITE.CUST_ACCOUNT_ID = p_customer_id