APPS.PER_VAC_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id
      from per_business_groups pbg
         , per_all_vacancies vac
     where vac.vacancy_id = p_vacancy_id
       and pbg.business_group_id = vac.business_group_id;

Line: 90

    select pbg.legislation_code
      from per_business_groups pbg
         , per_all_vacancies vac
     where vac.vacancy_id = p_vacancy_id
       and pbg.business_group_id = vac.business_group_id;

Line: 315

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

Line: 362

End chk_non_updateable_args;

Line: 395

         select null
           from per_all_vacancies
          where name = p_name
            and business_group_id = p_business_group_id;

Line: 777

         select date_from,date_to
         from  per_requisitions
         where  requisition_id = p_requisition_id
           and  business_group_id = p_business_group_id;

Line: 829

    select   hp.business_group_id
    from     hr_all_positions_f hp
           , per_shared_types ps
    where    hp.position_id    = p_position_id
    and      p_effective_date
    between  hp.effective_start_date
    and      hp.effective_end_date
    and      p_effective_date
    between  hp.date_effective
    and      nvl(hp.date_end, hr_api.g_eot)
    and      ps.shared_type_id = hp.availability_status_id
    and      ps.system_type_cd = 'ACTIVE' ;

Line: 924

    select   null
    from     per_valid_grades
    where    position_id = p_position_id
    and      grade_id = p_grade_id
    and      p_effective_date
    between  date_from
    and      nvl(date_to, hr_api.g_eot);

Line: 1004

    select   null
    from     hr_all_positions_f hp
    where    hp.position_id     = p_position_id
    and      p_effective_date
    between  hp.effective_start_date
    and      hp.effective_end_date
    and      hp.organization_id = p_organization_id;

Line: 1093

    select   null
    from     hr_all_positions_f hp
    where    hp.position_id = p_position_id
    and      p_effective_date
    between  hp.effective_start_date
    and      hp.effective_end_date
    and      hp.job_id = p_job_id;

Line: 1211

        select date_from,date_to
          from per_jobs
         where job_id = p_job_id
           and business_group_id = p_business_group_id;

Line: 1280

    select   null
    from     per_valid_grades
    where    job_id = p_job_id
    and      grade_id = p_grade_id
    and      p_effective_date
      between  date_from
      and      nvl(date_to, hr_api.g_eot);

Line: 1391

        select date_from,date_to
          from per_grades
         where grade_id = p_grade_id
           and business_group_id = p_business_group_id;

Line: 1481

        select date_from,date_to
          from hr_all_organization_units
         where organization_id = p_organization_id
           and business_group_id = p_business_group_id;

Line: 1567

        select start_date_active,end_date_active
          from pay_people_groups
         where people_group_id = p_people_group_id;

Line: 1650

        select null
          from hr_locations_all
         where location_id = p_location_id;

Line: 1734

        select null
          from per_all_people_f
         where person_id = p_recruiter_id
           and (p_business_group_id = business_group_id
            or (p_business_group_id <> business_group_id
           and nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y'));

Line: 1743

        select null
          from per_all_people_f
         where person_id = p_recruiter_id
           and p_effective_date between effective_start_date and effective_end_date;

Line: 1950

       select null
         from per_all_people_f
         where person_id = p_manager_id
           and(p_business_group_id = business_group_id
           or (p_business_group_id <> business_group_id
           and nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y'));

Line: 1958

        select null
          from per_all_people_f
         where person_id = p_manager_id
           and p_effective_date between effective_start_date and effective_end_date;

Line: 2050

	select null
	from per_all_assignments_f paf,per_all_people_f ppf
	where paf.vacancy_id = p_vacancy_id
	and ppf.person_id = paf.person_id
	and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
	and ppf.party_id = (select ppf.party_id
	from per_all_people_f ppf
	where ppf.person_id = p_manager_id
	and p_effective_date between ppf.effective_start_date and ppf.effective_end_date);

Line: 2136

        select null
          from irc_posting_contents
         where posting_content_id = p_primary_posting_id;

Line: 2212

        select null
          from ota_learning_objects
         where data_source='OIR'
           and test_id = p_assessment_id;

Line: 2256

Procedure insert_validate
  (p_rec                          in         per_vac_shd.g_rec_type
  ,p_effective_date               in         date
  ,p_inv_pos_grade_warning        out nocopy boolean
  ,p_inv_job_grade_warning        out nocopy boolean
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 2489

End insert_validate;

Line: 2494

Procedure update_validate
  (p_rec                          in            per_vac_shd.g_rec_type
  ,p_effective_date               in            date
  ,p_inv_pos_grade_warning           out nocopy boolean
  ,p_inv_job_grade_warning           out nocopy boolean
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 2513

  chk_non_updateable_args
  (p_rec              => p_rec
  );

Line: 2716

End update_validate;

Line: 2721

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

Line: 2733

End delete_validate;