APPS.OKL_EXECUTE_FORMULA_PVT SQL Statements

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

Line: 50

      SELECT source
        FROM okl_data_src_fnctns_v
       WHERE name = cp_function_name
       AND fnctn_code = 'ELIGIBILITY_CRITERIA';

Line: 81

     l_evaluated_string  := 'SELECT '||l_evaluated_string ||' FROM dual';

Line: 203

      SELECT fnctn_code
            ,name
            ,source
        FROM okl_data_src_fnctns_v
       WHERE id = cp_dsf_id;

Line: 210

      SELECT dsf_id
            ,pmr_id
            ,sequence_number
            ,value
            ,fpr_type
        FROM okl_fnctn_prmtrs_v
       WHERE dsf_id = cp_dsf_id
    ORDER BY sequence_number;

Line: 340

     l_evaluated_string  := 'SELECT '||l_evaluated_string ||' FROM dual';

Line: 492

      SELECT label
            ,opd_id
        FROM okl_fmla_oprnds_v
       WHERE fma_id = cp_fma_id;

Line: 498

      SELECT fma_id
            ,dsf_id
            ,name
            ,source
            ,opd_type

        FROM okl_operands_v
       WHERE id = cp_operand_id;

Line: 508

      SELECT name
            ,formula_string
        FROM okl_formulae_v

       WHERE id = cp_formula_id;

Line: 710

     l_evaluated_string  := 'SELECT '||l_evaluated_string ||' FROM dual';

Line: 849

      SELECT id
            ,formula_string
        FROM okl_formulae_v
       WHERE name = cp_formula_name
         AND start_date <= sysdate
         AND (end_date IS NULL OR end_date >= sysdate);

Line: 1026

      SELECT id
            ,formula_string

        FROM okl_formulae_v
       WHERE name = cp_formula_name
         AND start_date <= sysdate
         AND (end_date IS NULL OR end_date >= sysdate);