APPS.BEN_PUMP_GET SQL Statements

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

Line: 30

  select abr.acty_base_rt_id
  into   l_acty_base_rt_id
  from   ben_acty_base_rt_f abr
  where  abr.name                  = p_acty_base_rate_name1
  and    abr.business_group_id + 0 = p_business_group_id
  and    p_effective_date between
         abr.effective_start_date and abr.effective_end_date;

Line: 58

  select abr.acty_base_rt_id
  into   l_acty_base_rt_id
  from   ben_acty_base_rt_f abr
  where  abr.name                  = p_acty_base_rate_name2
  and    abr.business_group_id + 0 = p_business_group_id
  and    p_effective_date between
         abr.effective_start_date and abr.effective_end_date;

Line: 86

  select abr.acty_base_rt_id
  into   l_acty_base_rt_id
  from   ben_acty_base_rt_f abr
  where  abr.name                  = p_acty_base_rate_name3
  and    abr.business_group_id + 0 = p_business_group_id
  and    p_effective_date between
         abr.effective_start_date and abr.effective_end_date;

Line: 114

  select abr.acty_base_rt_id
  into   l_acty_base_rt_id
  from   ben_acty_base_rt_f abr
  where  abr.name                  = p_acty_base_rate_name4
  and    abr.business_group_id + 0 = p_business_group_id
  and    p_effective_date between
         abr.effective_start_date and abr.effective_end_date;

Line: 150

  select pgm.pgm_id
  into   l_pgm_id
  from   ben_pgm_f pgm
  where  pgm.name                  = p_program
  and    pgm.business_group_id + 0 = p_business_group_id
  and    p_effective_date between
         pgm.effective_start_date and pgm.effective_end_date;

Line: 179

  select pln.pl_id
  into   l_pl_id
  from   ben_pl_f pln
  where  pln.name                  = p_plan
  and    pln.business_group_id + 0 = p_business_group_id
  and    p_effective_date between
         pln.effective_start_date and pln.effective_end_date;

Line: 207

    select pln.pl_id
    into   l_pl_id
    from   ben_pl_f pln
    where  pln.name                  = p_ended_plan
    and    pln.business_group_id + 0 = p_business_group_id
    and    p_effective_date between
           pln.effective_start_date and pln.effective_end_date;

Line: 235

    select opt.opt_id
    into   l_opt_id
    from   ben_opt_f opt
    where  opt.name                  = p_option
    and    opt.business_group_id + 0 = p_business_group_id
    and    p_effective_date between
           opt.effective_start_date and opt.effective_end_date;

Line: 264

    select opt.opt_id
    into   l_opt_id
    from   ben_opt_f opt
    where  opt.name                  = p_ended_option
    and    opt.business_group_id + 0 = p_business_group_id
    and    p_effective_date between
           opt.effective_start_date and opt.effective_end_date;

Line: 311

      select person_id
        into l_person_id
        from per_all_people_f
      where business_group_id = p_business_group_id
        and p_effective_date between effective_start_date
                                 and effective_end_date
        and employee_number = p_employee_number ;

Line: 321

      select person_id
        into l_person_id
       from per_all_people_f
      where business_group_id = p_business_group_id
        and p_effective_date between effective_start_date
                                 and effective_end_date
        and national_identifier = p_national_identifier ;

Line: 331

      select person_id
        into l_person_id
       from per_all_people_f
      where business_group_id = p_business_group_id
        and p_effective_date between effective_start_date
                                 and effective_end_date
        and full_name  = p_full_name
        and date_of_birth = p_date_of_birth ;

Line: 378

      select person_id
        into l_person_id
        from per_all_people_f
      where business_group_id = p_business_group_id
        and p_effective_date between effective_start_date
                                 and effective_end_date
        and employee_number = p_con_employee_number ;

Line: 388

      select person_id
        into l_person_id
       from per_all_people_f
      where business_group_id = p_business_group_id
        and p_effective_date between effective_start_date
                                 and effective_end_date
        and national_identifier = p_con_national_identifier ;

Line: 398

      select person_id
        into l_person_id
       from per_all_people_f
      where business_group_id = p_business_group_id
        and p_effective_date between effective_start_date
                                 and effective_end_date
        and full_name  = p_con_full_name
        and date_of_birth = p_con_date_of_birth ;