DBA Data[Home] [Help]

APPS.OKS_RENCPY_PVT dependencies on HZ_CUST_SITE_USES_ALL

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

4244: l_error_text VARCHAR2(512);
4245:
4246: CURSOR c_party_from_billto(cp_bill_to_site_use_id IN NUMBER) IS
4247: SELECT cas.cust_account_id cust_account_id, ca.party_id party_id
4248: FROM hz_cust_site_uses_all csu, hz_cust_acct_sites_all cas, hz_cust_accounts_all ca
4249: WHERE csu.site_use_id = cp_bill_to_site_use_id
4250: AND cas.cust_acct_site_id = csu.cust_acct_site_id
4251: AND ca.cust_account_id = cas.cust_account_id;
4252: