APPS.QP_PRICE_BOOK_UTIL dependencies on QP_LIST_HEADERS_VL

Line 92: FROM qp_list_headers_vl

88: x_return NUMBER;
89: BEGIN
90: SELECT list_header_id
91: INTO x_return
92: FROM qp_list_headers_vl
93: WHERE name = p_price_list_name
94: AND list_type_code = 'PRL'
95: AND rownum = 1;
96: RETURN x_return;

Line 1794: FROM qp_list_headers_vl

1790: ELSE
1791: BEGIN
1792: SELECT 1
1793: INTO l_count
1794: FROM qp_list_headers_vl
1795: WHERE list_type_code = 'PRL'
1796: AND nvl(list_source_code, 'X') <> 'BSO'
1797: AND nvl(active_flag, 'N') = 'Y'
1798: AND (global_flag = 'Y' OR

Line 1875: FROM qp_list_headers_vl

1871: IF p_pb_input_header_rec.price_based_on = 'PRICE_LIST' THEN
1872: BEGIN
1873: SELECT 1
1874: INTO l_count
1875: FROM qp_list_headers_vl
1876: WHERE list_type_code = 'PRL'
1877: AND nvl(list_source_code, 'X') <> 'BSO'
1878: AND nvl(active_flag, 'N') = 'Y'
1879: AND (global_flag = 'Y' OR

Line 1920: FROM qp_list_headers_vl

1916: AND cust_account_id =
1917: nvl(p_pb_input_header_rec.cust_account_id, cust_account_id))
1918: )
1919: AND price_list_id IN (SELECT list_header_id
1920: FROM qp_list_headers_vl
1921: WHERE list_type_code IN ('PRL','AGR')
1922: AND nvl(active_flag, 'N') = 'Y'
1923: AND (global_flag = 'Y' OR
1924: orig_org_id = p_pb_input_header_rec.org_id)