APPS.AHL_VWP_RULES_PVT dependencies on QP_LIST_HEADERS_VL

Line 2877: FROM qp_list_headers_vl qlhv, FINANCIALS_SYSTEM_PARAMETERS FSP, qp_qualifiers qpq, GL_SETS_OF_BOOKS GSB

2873: l_customer_id NUMBER;
2874:
2875: /*CURSOR price_list_id_csr(p_price_list_name IN VARCHAR2,p_customer_id IN NUMBER)IS
2876: SELECT qlhv.list_header_id
2877: FROM qp_list_headers_vl qlhv, FINANCIALS_SYSTEM_PARAMETERS FSP, qp_qualifiers qpq, GL_SETS_OF_BOOKS GSB
2878: WHERE FSP.set_of_books_id = GSB.set_of_books_id
2879: AND qlhv.list_type_code = 'PRL'
2880: AND qlhv.currency_code = gsb.currency_code
2881: AND UPPER(qlhv.name) like UPPER(p_price_list_name)

Line 2888: FROM qp_list_headers_vl qlhv,oe_agreements oa, qp_qualifiers qpq, FINANCIALS_SYSTEM_PARAMETERS FSP, GL_SETS_OF_BOOKS GSB

2884: AND qpq.qualifier_context = 'CUSTOMER'
2885: AND qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE16'
2886: UNION
2887: SELECT qlhv.list_header_id
2888: FROM qp_list_headers_vl qlhv,oe_agreements oa, qp_qualifiers qpq, FINANCIALS_SYSTEM_PARAMETERS FSP, GL_SETS_OF_BOOKS GSB
2889: WHERE FSP.set_of_books_id = GSB.set_of_books_id
2890: AND ((oa.price_list_id = qlhv.list_header_id AND qlhv.list_type_code
2891: IN('PRL', 'AGR')) OR qlhv.list_type_code = 'PRL')
2892: AND qlhv.currency_code = gsb.currency_code

Line 2901: from qp_list_headers_vl qlhv, qp_qualifiers qpq

2897: AND qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE16';*/
2898:
2899: CURSOR price_list_id_csr(p_price_list_name IN VARCHAR2,p_customer_id IN NUMBER)IS
2900: SELECT qlhv.list_header_id
2901: from qp_list_headers_vl qlhv, qp_qualifiers qpq
2902: where qlhv.list_type_code = 'PRL'
2903: and upper(qlhv.name) like upper(p_price_list_name)
2904: and qpq.QUALIFIER_ATTR_VALUE = p_customer_id
2905: and qpq.list_header_id=qlhv.list_header_id