APPS.ASO_OPP_QTE_PUB dependencies on HZ_CUST_ACCOUNTS

Line 260: FROM hz_cust_accounts hca,hz_customer_profiles hcp

256: WHERE agreement_id = p_agreement_id;
257:
258: CURSOR c_pay_term_acct(p_cust_account_id IN Number) IS
259: SELECT hcp.standard_terms
260: FROM hz_cust_accounts hca,hz_customer_profiles hcp
261: WHERE hca.cust_account_id = p_cust_account_id
262: AND hcp.cust_account_id = hca.cust_account_id
263: AND nvl(hcp.status,'A') = 'A';
264: