APPS.OE_CNCL_VALIDATE_LINE dependencies on QP_LIST_HEADERS_VL

Line 2482: from qp_list_headers_vl

2478: BEGIN
2479: BEGIN
2480: select list_type_code
2481: into l_list_type_code
2482: from qp_list_headers_vl
2483: where list_header_id = p_line_rec.price_list_id;
2484: EXCEPTION WHEN NO_DATA_FOUND THEN
2485: null;
2486: END;

Line 2507: FROM qp_List_headers_vl

2503: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2504: BEGIN
2505: SELECT name
2506: INTO l_price_list_name
2507: FROM qp_List_headers_vl
2508: WHERE list_header_id = p_line_rec.price_list_id;
2509:
2510: Exception when no_data_found then
2511: l_price_list_name := p_line_rec.price_list_id;

Line 2518: FROM QP_List_headers_vl

2514: BEGIN
2515:
2516: SELECT name
2517: INTO l_price_list_name
2518: FROM QP_List_headers_vl
2519: WHERE list_header_id = l_price_list_id;
2520: EXCEPTION
2521: WHEN NO_DATA_FOUND THEN
2522: l_price_list_name := l_price_list_id;

Line 2595: -- modified by lkxu: to select from qp_list_headers_vl instead

2591:
2592: -- Allow only the non agreement price_lists
2593: BEGIN
2594: oe_debug_pub.add('Pricing date is '||p_line_rec.pricing_date,2);
2595: -- modified by lkxu: to select from qp_list_headers_vl instead
2596: -- of from qp_price_lists_v to select only PRL type list headers.
2597:
2598: SELECT name
2599: INTO l_price_list_name

Line 2600: FROM qp_list_headers_vl

2596: -- of from qp_price_lists_v to select only PRL type list headers.
2597:
2598: SELECT name
2599: INTO l_price_list_name
2600: FROM qp_list_headers_vl
2601: WHERE list_header_id = p_line_rec.price_list_id
2602: AND list_type_code = 'PRL';
2603:
2604: EXCEPTION