APPS.ARI_UTILITIES dependencies on HZ_CUST_ACCOUNTS

Line 820: hz_cust_accounts hca

816: select hca.cust_account_id
817: from hz_relationships hr,
818: hz_parties hp1,
819: hz_parties hp2,
820: hz_cust_accounts hca
821: where hr.subject_id = hp1.party_id
822: and hr.object_id = hp2.party_id
823: and subject_table_name = 'HZ_PARTIES'
824: and object_table_name = 'HZ_PARTIES'

Line 2133: from hz_parties hp,hz_cust_accounts hca

2129: and sites.site_use_id = aps.customer_site_use_id;
2130:
2131: select hp.party_name,hca.account_number
2132: into l_customer_acct_name,l_customer_acct_number
2133: from hz_parties hp,hz_cust_accounts hca
2134: where hp.party_id = hca.party_id
2135: and hca.cust_account_id = l_customer_id;
2136:
2137: IF (PG_DEBUG = 'Y') THEN

Line 2781: from hz_cust_accounts

2777: WHERE ps.customer_trx_id = p_customer_trx_id;
2778:
2779: cursor get_partyid(p_cust_acct_id number) is
2780: select party_id
2781: from hz_cust_accounts
2782: where cust_account_id = p_cust_acct_id;
2783:
2784: Cursor Get_billto(p_cust_trx_id number) Is
2785: select bill_to_site_use_id