DBA Data[Home] [Help]

APPS.ASO_QUOTE_HEADERS_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 7161: FROM hz_cust_accounts hca,hz_customer_profiles hcp

7157: Where quote_header_id = p_quote_header_id;
7158:
7159: CURSOR c_pay_term_acct(p_cust_account_id IN Number) IS
7160: SELECT hcp.standard_terms
7161: FROM hz_cust_accounts hca,hz_customer_profiles hcp
7162: WHERE hca.cust_account_id = p_cust_account_id
7163: AND hcp.cust_account_id = hca.cust_account_id
7164: AND nvl(hcp.status,'A') = 'A';
7165: