APPS.BEN_XCV_BUS SQL Statements

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

Line: 28

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

Line: 81

    select null
      from hr_standard_lookups
     where lookup_code  = p_lookup_code
       and lookup_type  = p_lookup_type
       and p_effective_date between
               nvl(start_date_active, p_effective_date)
           and nvl(end_date_active, p_effective_date);

Line: 127

  (p_insert               IN boolean
  ,p_business_group_id    IN number
  ,p_legislation_code     IN varchar2
  ,p_legislation_subgroup IN varchar2 DEFAULT NULL) IS
--
BEGIN
  --
  -- Call the supporting procedure to check startup mode
  --
  IF (p_insert) THEN
    --
    -- Call procedure to check startup_action for inserts.
    --
    hr_startup_data_api_support.chk_startup_action
      (p_generic_allowed   => TRUE
      ,p_startup_allowed   => TRUE
      ,p_user_allowed      => TRUE
      ,p_business_group_id => p_business_group_id
      ,p_legislation_code  => p_legislation_code
      ,p_legislation_subgroup => p_legislation_subgroup
      );

Line: 176

    select pbg.security_group_id
      from per_business_groups_perf pbg
         , ben_ext_crit_val xcv
     where xcv.ext_crit_val_id = p_ext_crit_val_id
       and pbg.business_group_id = xcv.business_group_id;

Line: 325

    select null
    from   ben_ext_crit_typ a
    where  a.ext_crit_typ_id = p_ext_crit_typ_id;

Line: 379

    select null
    from   per_business_groups_perf  a
    where  a.business_group_id  = p_ext_crit_bg_id ;

Line: 384

  select ecp.ext_global_flag
  from ben_ext_crit_prfl ecp ,
       ben_ext_crit_typ  ect
  where  ect.ext_crit_typ_id = p_ext_crit_typ_id
   and   ect.ext_crit_prfl_id = ecp.ext_crit_prfl_id
  ;

Line: 486

    select a.crit_typ_cd
    from   ben_ext_crit_typ a
    where  a.ext_crit_typ_id = p_ext_crit_typ_id;

Line: 491

    select null
    from   per_all_people_f per
    where  per.person_id = l_number
           and p_effective_date between per.effective_start_date
               and per.effective_end_date
           and per.business_group_id = p_business_group_id;

Line: 499

    select null
    from  hr_all_organization_units_vl  org
    where org.organization_id = l_number
      and org.internal_external_flag = 'INT'
      and p_effective_date between org.date_from
               and nvl(org.date_to,p_effective_date)
      and org.business_group_id = p_business_group_id;

Line: 508

    select null
    from  hr_locations loc
    where loc.location_id = l_number
      and p_effective_date <= nvl(loc.inactive_date,p_effective_date);

Line: 514

    select null
    from  hr_tax_units_v gre
    where gre.tax_unit_id = l_number
      and p_effective_date between gre.date_from
               and nvl(gre.date_to,p_effective_date)
      and gre.business_group_id = p_business_group_id;

Line: 522

    select null
    from   ben_pl_f pln
    where  pln.pl_id = l_number
           and p_effective_date between pln.effective_start_date
               and pln.effective_end_date
           and pln.business_group_id = p_business_group_id;

Line: 530

    select null
    from   ben_benfts_grp bgr
    where  bgr.benfts_grp_id = l_number
           and bgr.business_group_id = p_business_group_id;

Line: 536

    select null
    from   per_assignment_status_types ast
    where  ast.assignment_status_type_id = l_number
       and ast.active_flag = 'Y'
    ;

Line: 555

    select null
    from   ben_ext_crit_typ a,
           ben_ext_crit_val b
    where  a.ext_crit_typ_id = b.ext_crit_typ_id
      and  a.ext_crit_typ_id = p_ext_crit_typ_id
      and  b.val_1 = p_val_1;

Line: 564

    select null
    from   pay_event_groups
    where  event_group_id  = p_val_1
     ;

Line: 904

    select a.crit_typ_cd
    from   ben_ext_crit_typ a
    where  a.ext_crit_typ_id = p_ext_crit_typ_id;

Line: 909

    select null
    from   ben_ext_crit_typ a,
           ben_ext_crit_val b
    where  a.ext_crit_typ_id = b.ext_crit_typ_id
      and  a.ext_crit_typ_id = p_ext_crit_typ_id
      and  b.val_2 = p_val_2;

Line: 917

    select null
    from   ben_ext_crit_typ a,
           ben_ext_crit_val b
    where  a.ext_crit_typ_id = b.ext_crit_typ_id
      and  a.ext_crit_typ_id = p_ext_crit_typ_id
      and  b.val_1 = p_val_1
      and  b.val_2 = p_val_2;

Line: 1017

    select a.crit_typ_cd
    from   ben_ext_crit_typ a
    where  a.ext_crit_typ_id = p_ext_crit_typ_id;

Line: 1064

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

Line: 1128

End insert_validate;

Line: 1133

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

Line: 1197

End update_validate;

Line: 1202

Procedure delete_validate(p_rec in ben_xcv_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 1216

End delete_validate;

Line: 1229

    select a.legislation_code
    from   per_business_groups_perf  a,
           ben_ext_crit_val b
    where b.ext_crit_val_id      = p_ext_crit_val_id
    and   a.business_group_id(+) = b.business_group_id;