APPS.BEN_EVALUATE_ELIG_CRITERIA SQL Statements

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

Line: 142

 select 'x'
 from per_org_structure_versions a
 where a.org_structure_version_id = p_org_structure_version_id
   and p_effective_date between nvl(a.date_from,p_effective_date)
       and  nvl(a.date_to,p_effective_date) ;

Line: 150

  select 'x'
  from per_org_structure_elements a
  where a.ORG_STRUCTURE_VERSION_ID = p_org_structure_version_id
  and   a.business_group_id  = p_business_group_id
  and (a.organization_id_parent = p_organization_id
      or a.organization_id_child = p_organization_id)
  start with a.organization_id_parent = p_start_organization_id
  connect by prior a.organization_id_child  = a.organization_id_parent ;

Line: 161

 select 'x'
 from   per_org_structure_elements a
 where  a.organization_id_child  = p_organization_id
   and  a.organization_id_child  = p_start_organization_id
   and  a.business_group_id  = p_business_group_id
   and  a.ORG_STRUCTURE_VERSION_ID = p_org_structure_version_id
   ;

Line: 231

 select 'x'
 from per_pos_structure_versions a
 where a.pos_structure_version_id = p_pos_structure_version_id
   and p_effective_date between nvl(a.date_from,p_effective_date)
       and  nvl(a.date_to,p_effective_date) ;

Line: 239

  select 'x'
  from per_pos_structure_elements  a
  where a.POS_STRUCTURE_VERSION_ID = p_pos_structure_version_id
  and   a.business_group_id  = p_business_group_id
  and (a.parent_position_id = p_position_id
      or a.subordinate_position_id = p_position_id)
  start with a.parent_position_id = p_start_position_id
  connect by prior a.subordinate_position_id  = a.parent_position_id ;

Line: 253

 select 'x'
 from   per_pos_structure_elements a
 where  a.subordinate_position_id  = p_position_id
   and  a.subordinate_position_id  =  p_start_position_id
   and  a.business_group_id        = p_business_group_id
   and  a.POS_STRUCTURE_VERSION_ID = p_pos_structure_version_id
   ;

Line: 420

  l_statement  := 'Select  ' || p_column_name ||
                   ' From ' || p_table_name  || ' tbl ' ||
                   ' Where person_id =  ' || p_person_id  ||
                   ' and   to_date(''' || to_char(l_effective_date,'DD-MM-RRRR')|| ''',''DD-MM-RRRR'') ' ||
                   '  between tbl.effective_start_date   and   tbl.effective_end_date  ' ;

Line: 651

 select distinct egc.eligy_criteria_id
 from  ben_eligy_criteria egc,
       ben_eligy_crit_values_f egv
 where egv.eligy_prfl_id       = p_eligy_prfl_id
   and egv.eligy_criteria_id   = egc.eligy_criteria_id
   and egc.business_group_id   = p_business_group_id
   and egc.criteria_type      <> 'SEED'
   and l_effective_date between egv.effective_Start_date
        and egv.effective_end_date  ;

Line: 662

  select egc.criteria_type ,
        egc.crit_col1_val_type_cd,
        egc.crit_col1_datatype,
        egc.access_table_name1,
        egc.access_column_name1,
        egc.crit_col2_datatype,
        egc.access_table_name2,
        egc.access_column_name2,
        egc.access_calc_rule,
	egc.access_calc_rule2,
        egc.allow_range_validation_flag,
	egc.allow_range_validation_flag2,
        egc.name,
        egc.short_code
  from  ben_eligy_criteria egc
  where eligy_criteria_id = p_eligy_criteria_id ;

Line: 683

 select egv.number_value1 ,
        egv.number_value2 ,
        egv.char_value1 ,
        egv.char_value2 ,
        egv.date_value1 ,
        egv.date_value2 ,
	egv.number_value3 ,
        egv.number_value4 ,
        egv.char_value3 ,
        egv.char_value4 ,
        egv.date_value3 ,
        egv.date_value4 ,
        egv.EXCLD_FLAG
  from  ben_eligy_crit_values_f egv
  where egv.eligy_prfl_id = p_eligy_prfl_id
   and  egv.eligy_criteria_id = p_eligy_criteria_id
   and  egv.business_group_id = p_business_group_id
   and  p_effective_date between egv.effective_Start_date
        and egv.effective_end_date
  -- order by ordr_num
  ;