APPS.BEN_PEI_BUS SQL Statements

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

Line: 145

  select null
  from ben_pl_extract_identifier_F
  where
  p_rec.business_group_id           = business_group_id and
  nvl(p_rec.pl_extract_identifier_id, -1) <> pl_extract_identifier_id and
  nvl(p_rec.pl_id, -1)              = nvl(pl_id, -1) and
  nvl(p_rec.plip_id, -1)            = nvl(plip_id, -1) and
  nvl(p_rec.oipl_id, -1)            = nvl(oipl_id, -1) and
  nvl(p_rec.organization_id, -1)    = nvl(organization_id, -1) and
  nvl(p_rec.people_group_id, -1)    = nvl(people_group_id, -1) and
  nvl(p_rec.job_id, -1)             = nvl(job_id, -1) and
  nvl(p_rec.position_id, -1)        = nvl(position_id, -1) and
  nvl(p_rec.grade_id, -1)           = nvl(grade_id, -1) and
  nvl(p_rec.payroll_id, -1)         = nvl(payroll_id, -1) and
  nvl(p_rec.home_state, '~~NULL~~') = nvl(home_state, '~~NULL~~') and
  nvl(p_rec.home_zip, '~~NULL~~')   = nvl(home_zip, '~~NULL~~');

Line: 284

Procedure dt_update_validate
            (p_pl_id            	in number default hr_api.g_number,
	     p_plip_id          	in number default hr_api.g_number,
             p_oipl_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: 374

End dt_update_validate;

Line: 411

Procedure dt_delete_validate
            (p_pl_extract_identifier_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: 434

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

End dt_delete_validate;

Line: 480

Procedure insert_validate
    (p_rec                   in ben_pei_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: 520

End insert_validate;

Line: 525

Procedure update_validate
    (p_rec			in ben_pei_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: 550

  dt_update_validate
   (p_pl_id            	        => p_rec.pl_id,
    p_plip_id			=> p_rec.plip_id,
    p_oipl_id          		=> p_rec.oipl_id,
    p_datetrack_mode            => p_datetrack_mode,
    p_validation_start_date     => p_validation_start_date,
    p_validation_end_date       => p_validation_end_date
   );

Line: 576

End update_validate;

Line: 581

Procedure delete_validate
    (p_rec              in ben_pei_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: 595

  dt_delete_validate
    (p_datetrack_mode                  => p_datetrack_mode,
     p_validation_start_date           => p_validation_start_date,
     p_validation_end_date	       => p_validation_end_date,
     p_pl_extract_identifier_id        => p_rec.pl_extract_identifier_id);

Line: 602

End delete_validate;

Line: 614

    select a.legislation_code
    from   per_business_groups a,
           ben_pl_extract_identifier_f b
    where b.pl_extract_identifier_id      = p_pl_extract_identifier_id
    and   a.business_group_id = b.business_group_id;