APPS.PER_RCF_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_recruitment_activity_for rcf
     where rcf.recruitment_activity_for_id = p_rec_activity_for_id
       and pbg.business_group_id = rcf.business_group_id;

Line: 92

    select pbg.legislation_code
      from per_business_groups pbg
         , per_recruitment_activity_for rcf
     where rcf.recruitment_activity_for_id = p_rec_activity_for_id
       and pbg.business_group_id = rcf.business_group_id;

Line: 180

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

Line: 214

End chk_non_updateable_args;

Line: 262

  select l_vacancy_id,l_business_group_id
    from per_all_vacancies
  where vacancy_id = p_vacancy_id;

Line: 377

  select recruitment_activity_id, business_group_id
    from per_recruitment_activities
  where recruitment_activity_id = p_rec_activity_id;

Line: 489

  select null
    from irc_all_recruiting_sites irs
        ,per_recruitment_activities pra
        ,per_recruitment_activity_for prf
   where irs.recruiting_site_id = pra.recruiting_site_id
     and pra.recruitment_activity_id = prf.recruitment_activity_id
     and pra.recruitment_activity_id <> p_rec_activity_id
     and irs.internal = 'Y'
     and prf.vacancy_id = p_vacancy_id;

Line: 500

  select null
    from irc_all_recruiting_sites irs
        ,per_recruitment_activities pra
        ,per_recruitment_activity_for prf
   where irs.recruiting_site_id = pra.recruiting_site_id
     and pra.recruitment_activity_id = prf.recruitment_activity_id
     and pra.recruitment_activity_id <> p_rec_activity_id
     and irs.external = 'Y' and
     prf.vacancy_id = p_vacancy_id;

Line: 511

     select irs.internal
           ,irs.external
       from irc_all_recruiting_sites irs
           ,per_recruitment_activities pra
      where pra.recruitment_activity_id = p_rec_activity_id
        and pra.recruiting_site_id = irs.recruiting_site_id;

Line: 622

  select pra.date_start
    from irc_all_recruiting_sites irs
        ,per_recruitment_activities pra
        ,per_recruitment_activity_for prf
   where irs.recruiting_site_id = pra.recruiting_site_id
     and pra.recruitment_activity_id = prf.recruitment_activity_id
     and irs.internal = 'Y'
     and prf.vacancy_id = p_vacancy_id;

Line: 632

  select pra.date_start
    from irc_all_recruiting_sites irs
        ,per_recruitment_activities pra
        ,per_recruitment_activity_for prf
   where irs.recruiting_site_id = pra.recruiting_site_id
     and pra.recruitment_activity_id = prf.recruitment_activity_id
     and irs.external = 'Y' and
     prf.vacancy_id = p_vacancy_id;

Line: 642

     select irs.internal
           ,irs.external
           ,pra.date_start
       from irc_all_recruiting_sites irs
           ,per_recruitment_activities pra
      where pra.recruitment_activity_id = p_rec_activity_id
        and pra.recruiting_site_id = irs.recruiting_site_id;

Line: 755

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

Line: 807

End insert_validate;

Line: 812

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

Line: 825

  per_rcf_bus.chk_non_updateable_args
  (p_rec              => p_rec
  );

Line: 859

End update_validate;

Line: 864

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

Line: 876

End delete_validate;