DBA Data[Home] [Help]

APPS.BEN_EGL_BUS SQL Statements

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

Line: 109

cursor c1 is select null
             from   ben_eligy_criteria
             Where  eligy_criteria_id <> nvl(p_eligy_criteria_id,-1)
             and    name = p_name
             and    business_group_id = p_business_group_id;
Line: 167

cursor c1 is select null
             from   ben_eligy_criteria
             Where  eligy_criteria_id <> nvl(p_eligy_criteria_id,-1)
             and    short_code = p_short_code
             and    business_group_id = p_business_group_id;
Line: 472

      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: 484

      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: 589

     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: 683

      select null
        from fnd_flex_value_sets
        where flex_value_set_id  = p_col_value_set_id;
Line: 769

     select null
     from   ben_eligy_crit_values_f ecv
     where  ecv.eligy_criteria_id = p_eligy_criteria_id;
Line: 889

      select  table_id
        from  fnd_tables
        where table_name  = p_access_table_name;
Line: 894

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

   select null
      from   ben_eligy_crit_values_f ecv
      where  ecv.eligy_criteria_id = p_eligy_criteria_id;
Line: 1453

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

End insert_validate;
Line: 1613

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

End update_validate;
Line: 1804

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

End delete_validate;
Line: 1831

    select  a.legislation_code
     from   per_business_groups a,
            ben_eligy_criteria b
     where  b.eligy_criteria_id     = p_eligy_criteria_id
     and     a.business_group_id    = b.business_group_id;