DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 4845: FROM hz_cust_site_uses_all csu, hz_cust_acct_sites_all cas, hz_cust_accounts_all ca

4841: START WITH id = cp_line_id;
4842:
4843: CURSOR c_party_from_billto(cp_bill_to_site_use_id IN NUMBER) IS
4844: SELECT cas.cust_account_id cust_account_id, ca.party_id party_id
4845: FROM hz_cust_site_uses_all csu, hz_cust_acct_sites_all cas, hz_cust_accounts_all ca
4846: WHERE csu.site_use_id = cp_bill_to_site_use_id
4847: AND cas.cust_acct_site_id = csu.cust_acct_site_id
4848: AND ca.cust_account_id = cas.cust_account_id;
4849: