APPS.BEN_EVALUATE_RATE_MATRIX SQL Statements

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

Line: 31

select distinct pln.pl_id
  from ben_pl_f pln,
       pqh_rate_matrix_nodes rmn
 where p_effective_date between pln.effective_start_date
   and pln.effective_end_date
   and pln.business_group_id = p_business_group_id
   and pln.pl_id = rmn.pl_id
   and pln.pl_stat_cd = 'A';

Line: 41

select level,
       rmn.rate_matrix_node_id,
       rmn.pl_id,
       rmn.node_name,
       rmn.parent_node_id,
       rmn.eligy_prfl_id,
       rmn.business_group_id,
       rmn.level_number
  from pqh_rate_matrix_nodes rmn
start with rmn.rate_matrix_node_id in
           (select rate_matrix_node_id
              from pqh_rate_matrix_nodes
             where business_group_id = p_business_group_id
               and pl_id = p_pl_id
               and parent_node_id is null)
connect by prior rmn.rate_matrix_node_id = rmn.parent_node_id;

Line: 60

select rate_matrix_node_id,
       rate_matrix_rate_id,
       min_rate_value,
       max_rate_value,
       mid_rate_value,
       rate_value
  from pqh_rate_matrix_rates_f
 where rate_matrix_node_id = l_rate_matrix_rec.rate_matrix_node_id
   and p_effective_date between effective_start_date
   and effective_end_date
   and criteria_rate_defn_id = p_criteria_rate_defn_id;

Line: 134

        g_node_tbl.delete;