DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 151: from HZ_CUST_ACCOUNTS cust, qp_list_headers_vl pri

147: and trunc(nvl(pri.end_date_active, sysdate)) >= trunc(sysdate);
148:
149: CURSOR C_Customer_PL(p_cust_acct_id Number) Is
150: Select pri.list_header_id , pri.currency_code
151: from HZ_CUST_ACCOUNTS cust, qp_list_headers_vl pri
152: where cust.cust_account_id = p_cust_acct_id
153: and cust.price_list_id = pri.list_header_id
154: and pri.list_type_code in ('PRL','AGR')
155: and pri.active_flag = 'Y'