DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on HZ_CUST_SITE_USES_ALL

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

4832: START WITH id = cp_line_id;
4833:
4834: CURSOR c_party_from_billto(cp_bill_to_site_use_id IN NUMBER) IS
4835: SELECT cas.cust_account_id cust_account_id, ca.party_id party_id
4836: FROM hz_cust_site_uses_all csu, hz_cust_acct_sites_all cas, hz_cust_accounts_all ca
4837: WHERE csu.site_use_id = cp_bill_to_site_use_id
4838: AND cas.cust_acct_site_id = csu.cust_acct_site_id
4839: AND ca.cust_account_id = cas.cust_account_id;
4840: