DBA Data[Home] [Help]

APPS.ARI_UTILITIES dependencies on HZ_CUST_ACCOUNTS

Line 778: hz_cust_accounts hca

774: select hca.cust_account_id
775: from hz_relationships hr,
776: hz_parties hp1,
777: hz_parties hp2,
778: hz_cust_accounts hca
779: where hr.subject_id = hp1.party_id
780: and hr.object_id = hp2.party_id
781: and subject_table_name = 'HZ_PARTIES'
782: and object_table_name = 'HZ_PARTIES'

Line 2165: from hz_cust_accounts

2161: WHERE ps.customer_trx_id = p_customer_trx_id;
2162:
2163: cursor get_partyid(p_cust_acct_id number) is
2164: select party_id
2165: from hz_cust_accounts
2166: where cust_account_id = p_cust_acct_id;
2167:
2168: Cursor Get_billto(p_cust_trx_id number) Is
2169: select bill_to_site_use_id