APPS.OE_BLANKET_UTIL dependencies on QP_LIST_LINES

Line 2979: FROM QP_LIST_LINES

2975: BEGIN
2976:
2977: SELECT 'Y'
2978: INTO l_list_line_exists
2979: FROM QP_LIST_LINES
2980: WHERE LIST_LINE_ID = p_line_rec.qp_list_line_id;
2981:
2982: EXCEPTION
2983: WHEN NO_DATA_FOUND THEN

Line 5942: from qp_list_lines

5938: select decode(arithmetic_operator,'%',operand,null)
5939: ,decode(arithmetic_operator,'AMT',operand,null)
5940: into x_line_tbl(l_count).discount_percent
5941: ,x_line_tbl(l_count).discount_amount
5942: from qp_list_lines
5943: where list_line_id = x_line_tbl(l_count).modifier_list_line_id;
5944: EXCEPTION
5945: WHEN NO_DATA_FOUND THEN
5946: Null;

Line 6080: from qp_list_lines

6076: select decode(arithmetic_operator,'%',operand,null)
6077: ,decode(arithmetic_operator,'AMT',operand,null)
6078: into x_line_tbl(l_count).discount_percent
6079: ,x_line_tbl(l_count).discount_amount
6080: from qp_list_lines
6081: where list_line_id = x_line_tbl(l_count).modifier_list_line_id;
6082: EXCEPTION
6083: WHEN NO_DATA_FOUND THEN
6084: Null;