APPS.BEN_DPNT_EGD_BUS SQL Statements

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

Line: 110

    select null
             from   ben_eligy_criteria_dpnt
             Where  eligy_criteria_dpnt_id <> nvl(p_eligy_criteria_dpnt_id,-1)
             and    name = p_name
             and    business_group_id = p_business_group_id;

Line: 168

cursor c1 is select null
             from   ben_eligy_criteria_dpnt
             Where  eligy_criteria_dpnt_id <> nvl(p_eligy_criteria_dpnt_id,-1)
             and    short_code = p_short_code
             and    business_group_id = p_business_group_id;

Line: 473

      select  null
        from  hr_lookups
	where lookup_type  = p_col_lookup_type
         and  p_effective_date between
              nvl(start_date_active, p_effective_date)
         and  nvl(end_date_active, p_effective_date);

Line: 485

      SELECT NULL
        FROM fnd_lookup_types_vl flv
       WHERE lookup_type = cv_lookup_type
         AND (   customization_level IN ('E', 'S')
              OR (    customization_level = 'U'
                  AND (   security_group_id = 0
                       OR security_group_id IN (
                             SELECT security_group_id
                               FROM fnd_security_groups
                              WHERE security_group_key =
                                               TO_CHAR (cv_business_group_id))
                      )
                 )
             );

Line: 591

     SELECT NULL
       FROM ff_formulas_f
      WHERE formula_id = p_access_calc_rule
        AND formula_type_id = -552
        AND nvl(business_group_id, p_business_group_id) = p_business_group_id;

Line: 679

      select null
        from fnd_flex_value_sets
        where flex_value_set_id  = p_col_value_set_id;

Line: 765

     select null
     from   ben_dpnt_eligy_crit_values_f ecv
     where  ecv.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id;

Line: 885

      select  table_id
        from  fnd_tables
        where table_name  = p_access_table_name;

Line: 890

      select  null
        from  fnd_columns
        where table_id     = l_table_id
	and   column_name  = p_access_column_name;

Line: 1202

   select null
      from   ben_dpnt_eligy_crit_values_f ecv
      where  ecv.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id;

Line: 1442

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

Line: 1591

End insert_validate;

Line: 1596

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

Line: 1773

End update_validate;

Line: 1778

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

Line: 1792

End delete_validate;

Line: 1806

    select  a.legislation_code
     from   per_business_groups a,
            ben_eligy_criteria_dpnt b
     where  b.eligy_criteria_dpnt_id     = p_eligy_criteria_dpnt_id
     and     a.business_group_id    = b.business_group_id;