DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on HZ_CUST_ACCOUNTS_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:

Line 4852: FROM hz_cust_accounts_all ca

4848: AND ca.cust_account_id = cas.cust_account_id;
4849:
4850: CURSOR c_party_from_cust(cp_cust_acct_id IN NUMBER) IS
4851: SELECT ca.party_id party_id
4852: FROM hz_cust_accounts_all ca
4853: WHERE ca.cust_account_id = cp_cust_acct_id;
4854:
4855: CURSOR c_get_notes(cp_source_object_id IN NUMBER) IS
4856: SELECT jtf_note_id