APPS.PER_PJU_BUS SQL Statements

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

Line: 50

    select previous_employer_id
    from   per_previous_employers
    where  previous_employer_id = p_previous_employer_id
    and    all_assignments = 'N';

Line: 129

    select  previous_job_id
    from    per_previous_jobs
    where   previous_job_id = p_previous_job_id
    and     all_assignments = 'N';

Line: 208

    select  assignment_id
    from    per_all_assignments_f
    where   assignment_id = p_assignment_id;

Line: 572

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

    select  previous_job_usage_id
    from    per_previous_job_usages
    where   assignment_id   = p_assignment_id
    and     previous_job_id = p_previous_job_id;

Line: 760

  select start_date
        ,end_date
        ,period_years
        ,period_months
        ,period_days
  from   per_previous_jobs pjo
  where  pjo.previous_employer_id = p_previous_employer_id
  and    pjo.previous_job_id      = p_previous_job_id;

Line: 837

  select 'x' from  per_previous_jobs pjo
                  ,per_all_assignments_f asg
  where pjo.start_date >= asg.effective_start_date
  and   pjo.previous_job_id = p_previous_job_id
  and   asg.assignment_id   = p_assignment_id;

Line: 888

    select pbg.security_group_id
      from per_business_groups pbg
         , per_previous_job_usages pju
         , per_previous_jobs       pjo
         , per_previous_employers  pem
     where pju.previous_job_usage_id = p_previous_job_usage_id
     and   pju.previous_job_id(+)    = pjo.previous_job_id
     and   pjo.previous_employer_id  = pem.previous_employer_id
     and   pbg.business_group_id     = pem.business_group_id;

Line: 951

    select  pbg.legislation_code
    from    per_business_groups     pbg
          , per_previous_job_usages pju
          , per_previous_employers  pem
    where pju.previous_job_usage_id = p_previous_job_usage_id
    and   pju.previous_employer_id  = pem.previous_employer_id(+)
    and   pem.business_group_id     = pbg.business_group_id(+);

Line: 1315

Procedure chk_non_updateable_args
  (p_rec in per_pju_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 1361

End chk_non_updateable_args;

Line: 1366

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

Line: 1477

End insert_validate;

Line: 1482

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

Line: 1498

    chk_non_updateable_args(p_rec => p_rec);

Line: 1586

End update_validate;

Line: 1591

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

Line: 1603

End delete_validate;