DBA Data[Home] [Help]

APPS.OTA_TDB_BUS2 dependencies on HZ_PARTY_SITES

Line 511: HZ_PARTY_SITES party_site

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
515: and ACCT_SITE.CUST_ACCT_SITE_ID = p_contact_address_id