APPS.QP_FORMULA_RULES_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 83

  select replace(l_formula,'''','''''') into l_formula from dual;--6726052,7249280 smbalara

Line: 199

        select line, text
        from user_errors
        where name = upper(l_pkg_name)
          and type = decode(p_pkg_type,'SPEC','PACKAGE',
                                        'BODY','PACKAGE BODY');

Line: 403

    SELECT distinct formula
    FROM   qp_price_formulas_b
    WHERE NVL(end_date_active,SYSDATE) >= SYSDATE;  --Added for 5713302 to discard expired formulas

Line: 418

l_select_stmt            VARCHAR2(32000) := '';

Line: 473

     l_select_stmt := '';

Line: 593

	 l_expression := 'declare l_res number; TYPE t_Operand_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; p_Operand_Tbl t_Operand_Tbl_Type; begin Select ' || l_new_formula || ' into l_res from dual; end;';

Line: 622

        l_select_stmt := 'SELECT '|| l_new_formula || ' INTO x_formula_value FROM DUAL';

Line: 623

        Break_Text(l_select_stmt, 4);

Line: 628

	select replace(l_temp_new_formula,'''','''''') into l_temp_new_formula from dual;--6726052,7249280 smbalara

Line: 629

        l_select_stmt := 'EXECUTE IMMEDIATE '' SELECT '|| l_temp_new_formula || ' FROM DUAL '' INTO x_formula_value using ' || l_using_clause;

Line: 630

        Break_Text(l_select_stmt, 4);