APPS.PER_RCF_BUS dependencies on IRC_ALL_RECRUITING_SITES

Line 484: l_internal irc_all_recruiting_sites.internal%type;

480: ) IS
481: --
482: l_proc varchar2(72) := g_package || 'chk_vacancy_rec_activity';
483: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;
484: l_internal irc_all_recruiting_sites.internal%type;
485: l_external irc_all_recruiting_sites.external%type;
486: l_ret varchar2(1);
487: --
488: cursor csr_internal is

Line 485: l_external irc_all_recruiting_sites.external%type;

481: --
482: l_proc varchar2(72) := g_package || 'chk_vacancy_rec_activity';
483: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;
484: l_internal irc_all_recruiting_sites.internal%type;
485: l_external irc_all_recruiting_sites.external%type;
486: l_ret varchar2(1);
487: --
488: cursor csr_internal is
489: select null

Line 490: from irc_all_recruiting_sites irs

486: l_ret varchar2(1);
487: --
488: cursor csr_internal is
489: select null
490: from irc_all_recruiting_sites irs
491: ,per_recruitment_activities pra
492: ,per_recruitment_activity_for prf
493: where irs.recruiting_site_id = pra.recruiting_site_id
494: and pra.recruitment_activity_id = prf.recruitment_activity_id

Line 501: from irc_all_recruiting_sites irs

497: and prf.vacancy_id = p_vacancy_id;
498: --
499: cursor csr_external is
500: select null
501: from irc_all_recruiting_sites irs
502: ,per_recruitment_activities pra
503: ,per_recruitment_activity_for prf
504: where irs.recruiting_site_id = pra.recruiting_site_id
505: and pra.recruitment_activity_id = prf.recruitment_activity_id

Line 513: from irc_all_recruiting_sites irs

509: --
510: cursor csr_rse is
511: select irs.internal
512: ,irs.external
513: from irc_all_recruiting_sites irs
514: ,per_recruitment_activities pra
515: where pra.recruitment_activity_id = p_rec_activity_id
516: and pra.recruiting_site_id = irs.recruiting_site_id;
517: --

Line 615: l_internal irc_all_recruiting_sites.internal%type;

611: ) IS
612: --
613: l_proc varchar2(72) := g_package || 'chk_rec_activity_dates';
614: l_ret varchar2(1);
615: l_internal irc_all_recruiting_sites.internal%type;
616: l_external irc_all_recruiting_sites.external%type;
617: l_start_date per_recruitment_activities.date_start%type;
618: l_start_date_exists per_recruitment_activities.date_start%type;
619: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;

Line 616: l_external irc_all_recruiting_sites.external%type;

612: --
613: l_proc varchar2(72) := g_package || 'chk_rec_activity_dates';
614: l_ret varchar2(1);
615: l_internal irc_all_recruiting_sites.internal%type;
616: l_external irc_all_recruiting_sites.external%type;
617: l_start_date per_recruitment_activities.date_start%type;
618: l_start_date_exists per_recruitment_activities.date_start%type;
619: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;
620: cursor csr_internal is

Line 623: from irc_all_recruiting_sites irs

619: l_vacancy_id per_recruitment_activity_for.vacancy_id%type;
620: cursor csr_internal is
621: --
622: select pra.date_start
623: from irc_all_recruiting_sites irs
624: ,per_recruitment_activities pra
625: ,per_recruitment_activity_for prf
626: where irs.recruiting_site_id = pra.recruiting_site_id
627: and pra.recruitment_activity_id = prf.recruitment_activity_id

Line 633: from irc_all_recruiting_sites irs

629: and prf.vacancy_id = p_vacancy_id;
630: --
631: cursor csr_external is
632: select pra.date_start
633: from irc_all_recruiting_sites irs
634: ,per_recruitment_activities pra
635: ,per_recruitment_activity_for prf
636: where irs.recruiting_site_id = pra.recruiting_site_id
637: and pra.recruitment_activity_id = prf.recruitment_activity_id

Line 645: from irc_all_recruiting_sites irs

641: cursor csr_rse is
642: select irs.internal
643: ,irs.external
644: ,pra.date_start
645: from irc_all_recruiting_sites irs
646: ,per_recruitment_activities pra
647: where pra.recruitment_activity_id = p_rec_activity_id
648: and pra.recruiting_site_id = irs.recruiting_site_id;
649: --