5463: --It is special char define for the pricelist
5464: --if customer wants to call order Capture price API
5465: CURSOR get_pricelist_comment(p_list_header_id NUMBER)
5466: IS
5467: SELECT 'Y' FROM QP_LIST_HEADERS_B
5468: WHERE LIST_HEADER_ID = p_list_header_id
5469: AND COMMENTS LIKE '%999';
5470:
5471: --check if this pricelist has any dynamic formula
6070: BEGIN
6071:
6072: SELECT currency_code
6073: INTO l_pl_curr_code
6074: FROM qp_list_headers_b
6075: WHERE list_header_id = p_price_list_id;
6076:
6077: return l_pl_curr_code;
6078: