APPS.BEN_DPNT_EDC_BUS SQL Statements

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

Line: 120

         select NULL
         from ben_eligy_criteria_dpnt
         where eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id;

Line: 197

         select NULL
         from ben_dpnt_cvg_eligy_prfl_f
         where dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id;

Line: 268

     select null
       from ben_dpnt_eligy_crit_values_f edc
      where edc.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
        and edc.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id
        and edc.dpnt_eligy_crit_values_id <> nvl ( p_dpnt_eligy_crit_values_id, -1)
	and nvl(edc.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)
	and nvl(edc.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)
	and nvl(edc.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
	and nvl(edc.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
	and nvl(edc.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
	and nvl(edc.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)
	and nvl(edc.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)
	and nvl(edc.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)
	and nvl(edc.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)
	and nvl(edc.char_value4,hr_api.g_varchar2) = nvl(p_char_value4,hr_api.g_varchar2)
	and nvl(edc.date_value3,hr_api.g_date) = nvl (p_date_value3,hr_api.g_date)
	and nvl(edc.date_value4,hr_api.g_date) = nvl (p_date_value4,hr_api.g_date)
	and edc.effective_start_date <= p_validation_end_date
        and edc.effective_end_date >= p_validation_start_date
        and edc.business_group_id = p_business_group_id;

Line: 355

     select null
       from ben_dpnt_eligy_crit_values_f
      where dpnt_eligy_crit_values_id <> nvl( p_dpnt_eligy_crit_values_id, -1 )
        and dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
        and ordr_num = p_ordr_num
        and business_group_id = p_business_group_id
        and effective_start_date <= p_validation_end_date
        and effective_end_date   >= p_validation_start_date;

Line: 433

     select crit_col1_val_type_cd, crit_col1_datatype, col1_lookup_type, allow_range_validation_flag,
            crit_col2_val_type_cd, crit_col2_datatype, col2_lookup_type, allow_range_validation_flag2
       from ben_eligy_criteria_dpnt egl
      where egl.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id
        and egl.business_group_id = p_business_group_id;

Line: 440

     select null
       from per_org_structure_versions osv
      where osv.business_group_id = p_business_group_id
        and osv.org_structure_version_id = p_number_value1
        and p_effective_date between osv.date_from
                                 and nvl (osv.date_to, p_effective_date );

Line: 448

     select null
       from per_org_structure_elements ose
      where ose.org_structure_version_id = p_number_value1
        and ( ose.organization_id_parent = p_number_value2 or
              ose.organization_id_child = p_number_value2
             );

Line: 456

     select null
       from per_pos_structure_versions psv
      where psv.business_group_id = p_business_group_id
        and psv.pos_structure_version_id = p_number_value1
        and p_effective_date between psv.date_from
                                 and nvl (psv.date_to, p_effective_date );

Line: 464

     select null
       from per_pos_structure_elements pse
      where pse.pos_structure_version_id = p_number_value1
        and ( pse.parent_position_id = p_number_value2 or
              pse.subordinate_position_id = p_number_value2
             );

Line: 473

     select null
       from per_org_structure_versions osv
      where osv.business_group_id = p_business_group_id
        and osv.org_structure_version_id = p_number_value3
        and p_effective_date between osv.date_from
                                 and nvl (osv.date_to, p_effective_date );

Line: 481

     select null
       from per_org_structure_elements ose
      where ose.org_structure_version_id = p_number_value3
        and ( ose.organization_id_parent = p_number_value4 or
              ose.organization_id_child = p_number_value4
             );

Line: 489

     select null
       from per_pos_structure_versions psv
      where psv.business_group_id = p_business_group_id
        and psv.pos_structure_version_id = p_number_value3
        and p_effective_date between psv.date_from
                                 and nvl (psv.date_to, p_effective_date );

Line: 497

     select null
       from per_pos_structure_elements pse
      where pse.pos_structure_version_id = p_number_value3
        and ( pse.parent_position_id = p_number_value4 or
              pse.subordinate_position_id = p_number_value4
             );

Line: 693

procedure dt_update_validate
          (p_eligy_criteria_dpnt_id       In number default hr_api.g_number,
           p_dpnt_cvg_eligy_prfl_id           In number default hr_api.g_number,
           p_datetrack_mode          In Varchar2,
           p_validation_start_date   In Date,
           p_validation_end_date     In Date
           ) Is
  --
  l_proc    varchar2(72)    :=   g_package||'dt_update_validate';

Line: 773

end dt_update_validate;

Line: 809

Procedure dt_delete_validate
            (p_dpnt_eligy_crit_values_id	   	in number,
             p_datetrack_mode	    	in varchar2,
	         p_validation_start_date	in date,
	         p_validation_end_date	    in date) Is
--
  l_proc	varchar2(72) 	:= g_package||'dt_delete_validate';

Line: 832

  If (p_datetrack_mode = 'DELETE' or
      p_datetrack_mode = 'ZAP') then
    --
    --
    -- Ensure the arguments are not null
    --
    hr_api.mandatory_arg_error
      (p_api_name       => l_proc,
       p_argument       => 'validation_start_date',
       p_argument_value => p_validation_start_date);

Line: 855

end dt_delete_validate;

Line: 860

Procedure insert_validate
	(p_rec 			 in ben_dpnt_edc_shd.g_rec_type,
	 p_effective_date	 in date,
	 p_datetrack_mode	 in varchar2,
	 p_validation_start_date in date,
	 p_validation_end_date	 in date) is
--
  l_proc	varchar2(72) := g_package||'insert_validate';

Line: 939

end insert_validate;

Line: 944

Procedure update_validate
	(p_rec 			 in ben_dpnt_edc_shd.g_rec_type,
	 p_effective_date	 in date,
	 p_datetrack_mode	 in varchar2,
	 p_validation_start_date in date,
	 p_validation_end_date	 in date) is
  --
  l_proc varchar2(72)   :=   g_package||'update_validate';

Line: 1025

  dt_update_validate( p_eligy_criteria_dpnt_id            => p_rec.eligy_criteria_dpnt_id,
                      p_dpnt_cvg_eligy_prfl_id                => p_rec.dpnt_cvg_eligy_prfl_id,
                      p_datetrack_mode               => p_datetrack_mode,
                      p_validation_start_date        => p_validation_start_date,
                      p_validation_end_date          => p_validation_end_date );

Line: 1034

end update_validate;

Line: 1039

Procedure delete_validate
	(p_rec 			 in ben_dpnt_edc_shd.g_rec_type,
	 p_effective_date	 in date,
	 p_datetrack_mode	 in varchar2,
	 p_validation_start_date in date,
	 p_validation_end_date	 in date) is
  --
  l_proc   varchar2(72)   :=   g_package||'delete_validate';

Line: 1059

 dt_delete_validate
                  (
				  p_dpnt_eligy_crit_values_id	   	=> p_rec.dpnt_eligy_crit_values_id,
                  p_datetrack_mode	            => p_datetrack_mode,
	              p_validation_start_date	    => p_validation_start_date,
	              p_validation_end_date	        => p_validation_end_date
			 );

Line: 1066

end delete_validate;

Line: 1078

    select a.legislation_code
    from   per_business_groups a,
           ben_dpnt_eligy_crit_values_f b
    where b.dpnt_eligy_crit_values_id      = p_dpnt_eligy_crit_values_id
    and   a.business_group_id = b.business_group_id;