APPS.AHL_VWP_RULES_PVT dependencies on QP_LIST_HEADERS_VL

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

2554: l_customer_id NUMBER;
2555:
2556: /*CURSOR price_list_id_csr(p_price_list_name IN VARCHAR2,p_customer_id IN NUMBER)IS
2557: SELECT qlhv.list_header_id
2558: FROM qp_list_headers_vl qlhv, FINANCIALS_SYSTEM_PARAMETERS FSP, qp_qualifiers qpq, GL_SETS_OF_BOOKS GSB
2559: WHERE FSP.set_of_books_id = GSB.set_of_books_id
2560: AND qlhv.list_type_code = 'PRL'
2561: AND qlhv.currency_code = gsb.currency_code
2562: AND UPPER(qlhv.name) like UPPER(p_price_list_name)

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

2565: AND qpq.qualifier_context = 'CUSTOMER'
2566: AND qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE16'
2567: UNION
2568: SELECT qlhv.list_header_id
2569: FROM qp_list_headers_vl qlhv,oe_agreements oa, qp_qualifiers qpq, FINANCIALS_SYSTEM_PARAMETERS FSP, GL_SETS_OF_BOOKS GSB
2570: WHERE FSP.set_of_books_id = GSB.set_of_books_id
2571: AND ((oa.price_list_id = qlhv.list_header_id AND qlhv.list_type_code
2572: IN('PRL', 'AGR')) OR qlhv.list_type_code = 'PRL')
2573: AND qlhv.currency_code = gsb.currency_code

Line 2582: from qp_list_headers_vl qlhv, qp_qualifiers qpq

2578: AND qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE16';*/
2579:
2580: CURSOR price_list_id_csr(p_price_list_name IN VARCHAR2,p_customer_id IN NUMBER)IS
2581: SELECT qlhv.list_header_id
2582: from qp_list_headers_vl qlhv, qp_qualifiers qpq
2583: where qlhv.list_type_code = 'PRL'
2584: and upper(qlhv.name) like upper(p_price_list_name)
2585: and qpq.QUALIFIER_ATTR_VALUE = p_customer_id
2586: and qpq.list_header_id=qlhv.list_header_id