APPS.ASO_QUOTE_HEADERS_PVT dependencies on HZ_CUST_ACCOUNTS

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:

Line 7186: from HZ_CUST_ACCOUNTS cust, qp_list_headers_vl pri

7182: and trunc(nvl(pri.end_date_active, sysdate)) >= trunc(sysdate);
7183:
7184: CURSOR C_Customer_PL(p_cust_acct_id Number) Is
7185: Select pri.list_header_id , pri.currency_code
7186: from HZ_CUST_ACCOUNTS cust, qp_list_headers_vl pri
7187: where cust.cust_account_id = p_cust_acct_id
7188: and cust.price_list_id = pri.list_header_id
7189: and pri.list_type_code in ('PRL','AGR')
7190: and pri.active_flag = 'Y'