APPS.JAI_ETCS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 2921: Hence joined hz_parties and hz_cust_accounts to get Party Name

2917:
2918:
2919: /*
2920: Bug 8429168 - Customer Account ID was passed as parameter
2921: Hence joined hz_parties and hz_cust_accounts to get Party Name
2922: */
2923: cursor c_cust_name(cp_customer_id in number)
2924: is
2925: select hp.party_name

Line 2926: from hz_parties hp, hz_cust_accounts hca

2922: */
2923: cursor c_cust_name(cp_customer_id in number)
2924: is
2925: select hp.party_name
2926: from hz_parties hp, hz_cust_accounts hca
2927: where hca.cust_account_id = cp_customer_id
2928: and hca.party_id = hp.party_id;
2929:
2930: