DBA Data[Home] [Help]

APPS.ASO_PRICING_FLOWS_PVT dependencies on FND_PROFILE

Line 752: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id

748:
749: -- Cursors used for the customer account (Sold_to_org_id)
750: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
751: CURSOR c_get_cust_acct_id IS
752: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id
753: from ASO_QUOTE_HEADERS_ALL
754: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
755:
756: CURSOR c_get_cust_acct_id_ln(p_qte_line_id number) IS

Line 757: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID) cust_account_id

753: from ASO_QUOTE_HEADERS_ALL
754: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
755:
756: CURSOR c_get_cust_acct_id_ln(p_qte_line_id number) IS
757: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID) cust_account_id
758: from ASO_QUOTE_LINES_ALL
759: WHERE quote_line_id = p_qte_line_id;
760:
761: cursor c_get_price_list(p_qte_hdr_id number) is