APPS.IRC_IAV_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id,
           pbg.legislation_code
      from per_business_groups_perf pbg
         , per_all_vacancies pav
     where pav.vacancy_id = p_vacancy_id
       and pbg.business_group_id = pav.business_group_id;

Line: 99

    select pbg.legislation_code
      from per_business_groups_perf pbg
         , per_all_vacancies pav
     where pav.vacancy_id = p_vacancy_id
       and pbg.business_group_id = pav.business_group_id;

Line: 365

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

Line: 389

End chk_non_updateable_args;

Line: 425

    select 1
      from po_vendors
     where vendor_id = p_agency_id
       and vendor_type_lookup_code = 'IRC_JOB_AGENCY';

Line: 506

  select vacancy_id
    from per_all_vacancies
  where vacancy_id = p_vacancy_id
  and p_start_date between date_from and nvl(date_to,hr_api.g_eot);

Line: 667

  select agency_vacancy_id
    from irc_agency_vacancies
   where agency_id = p_agency_id
     and vacancy_id = p_vacancy_id;

Line: 673

  select agency_vacancy_id
    from irc_agency_vacancies
   where agency_id = p_agency_id
     and vacancy_id = p_vacancy_id
     and agency_vacancy_id <> p_agency_vacancy_id;

Line: 827

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

Line: 880

End insert_validate;

Line: 885

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

Line: 904

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 942

End update_validate;

Line: 947

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

Line: 959

End delete_validate;