DBA Data[Home] [Help]

APPS.OKS_RENCPY_PVT dependencies on HZ_CUST_SITE_USES_ALL

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

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