APPS.PER_PJO_BUS SQL Statements

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

Line: 29

    select pbg.security_group_id
      from per_business_groups pbg
         , per_previous_jobs pjo
         , per_all_people_f ppf
         , per_previous_employers pem
     where pjo.previous_job_id = p_previous_job_id
     and   pbg.business_group_id = ppf.business_group_id
     and   pem.person_id = ppf.person_id
     and   pem.previous_employer_id = pjo.previous_employer_id;

Line: 96

     select pbg.legislation_code
     from  per_business_groups     pbg
         , per_previous_jobs       pjo
         , per_all_people_f        ppf
         , per_previous_employers  pem
     where pjo.previous_job_id      = p_previous_job_id
     and   ppf.business_group_id    = pbg.business_group_id(+)
     and   pem.person_id            = ppf.person_id(+)
     and   pjo.previous_employer_id = pem.previous_employer_id;

Line: 542

Procedure chk_non_updateable_args
  (p_effective_date               in date
  ,p_rec in per_pjo_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 585

End chk_non_updateable_args;

Line: 618

    select previous_employer_id
    from   per_previous_employers
    where  previous_employer_id = p_previous_employer_id;

Line: 1091

    select  previous_employer_id
    from    per_previous_employers
    where   previous_employer_id = p_previous_employer_id
    and     (p_start_date not between nvl(start_date,hr_api.g_sot)
                              and     nvl(end_date,hr_api.g_eot)
             or p_end_date not between nvl(start_date,hr_api.g_sot)
                               and     nvl(end_date,hr_api.g_eot));

Line: 1199

       select previous_job_usage_id
       from   per_previous_job_usages
       where  previous_job_id = p_previous_job_id;

Line: 1261

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

Line: 1360

End insert_validate;

Line: 1365

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

Line: 1384

    chk_non_updateable_args
    (p_effective_date   => p_effective_date
    ,p_rec              => p_rec
    );

Line: 1456

End update_validate;

Line: 1461

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

Line: 1473

End delete_validate;

Line: 1485

          select pbg.legislation_code
            from per_business_groups pbg,
                 per_all_people_f ppf,
                 per_previous_employers pem
           where pem.previous_employer_id = p_previous_employer_id
             and ppf.business_group_id    = pbg.business_group_id(+)
             and pem.person_id            = ppf.person_id(+);