APPS.OKL_EC_EVALUATE_PVT SQL Statements

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

Line: 11

      SELECT meaning
      FROM   fnd_lookups fnd
      WHERE  fnd.lookup_type = p_lookup_type
         AND fnd.lookup_code = p_lookup_code;

Line: 109

      SELECT meaning
      FROM   fnd_lookups
      WHERE  lookup_type = 'OKL_FE_OPERATORS' AND lookup_code = p_operator;

Line: 1148

      SELECT ech.match_criteria_code mc_hdr
            ,ech.validation_code
            ,fun.name evaluation_function
            ,ecl.criteria_id
            ,ecl.match_criteria_code
            ,ecl.effective_from_date
            ,ecl.effective_to_date
            ,ecc.value_type_code
            ,ecc.seeded_yn
            ,ecc.crit_cat_name ec_name
      FROM   okl_fe_criteria_set ech
            ,okl_fe_criteria ecl
            ,okl_fe_crit_cat_def_v ecc
            ,okl_data_src_fnctns_v fun
      WHERE  ech.criteria_set_id = ecl.criteria_set_id
         AND ech.source_id = src_id
         AND ech.source_object_code = src_obj_code
         AND ecl.crit_cat_def_id = ecc.crit_cat_def_id
         AND ecc.ecc_ac_flag = 'ECC'
         AND ecc.function_id = fun.id;

Line: 1172

      SELECT operator_code
            ,crit_cat_value1
            ,crit_cat_value2
      FROM   okl_fe_criterion_values
      WHERE  criteria_id = ec_ln_id;

Line: 2067

      SELECT fun.name evaluation_function
            ,ecl.criteria_id
            ,ecl.effective_from_date
            ,ecl.effective_to_date
            ,ecc.value_type_code
            ,ecc.seeded_yn
            ,ecc.crit_cat_name ac_name
      FROM   okl_fe_criteria_set ech
            ,okl_fe_criteria ecl
            ,okl_fe_crit_cat_def_v ecc
            ,okl_data_src_fnctns_v fun
      WHERE  ech.criteria_set_id = ecl.criteria_set_id
         AND ech.source_id = src_id
         AND ech.source_object_code = src_obj_code
         AND ecl.crit_cat_def_id = ecc.crit_cat_def_id
         AND ecc.ecc_ac_flag = 'AC'
         AND ecc.function_id = fun.id;

Line: 2088

      SELECT operator_code
            ,crit_cat_value1
            ,crit_cat_value2
            ,adjustment_factor
      FROM   okl_fe_criterion_values
      WHERE  criteria_id = ec_ln_id;

Line: 2390

      SELECT a.validation_code
            ,b.criteria_id
            ,b.match_criteria_code
            ,b.effective_from_date
            ,b.effective_to_date
            ,c.value_type_code
            ,c.data_type_code
            ,c.crit_cat_name ec_name
            ,c.crit_cat_def_id
      FROM   okl_fe_criteria_set a
            ,okl_fe_criteria b
            ,okl_fe_crit_cat_def_v c
      WHERE  a.criteria_set_id = b.criteria_set_id AND a.source_id = src_id
         AND a.source_object_code = src_obj_code
         AND b.crit_cat_def_id = c.crit_cat_def_id
         AND c.ecc_ac_flag = 'ECC';

Line: 2410

      SELECT operator_code
            ,crit_cat_value1
            ,crit_cat_value2
      FROM   okl_fe_criterion_values
      WHERE  criteria_id = ec_ln_id;