629: l_int_site irc_all_recruiting_sites.internal%type;
630: BEGIN
631:
632: SELECT 'Y' INTO l_int_site
633: FROM DUAL
634: WHERE EXISTS ( SELECT 1
635: FROM per_all_vacancies vac ,
636: per_recruitment_activity_for praf ,
637: per_recruitment_activities pra ,
664: l_ext_site irc_all_recruiting_sites.external%type;
665: BEGIN
666:
667: SELECT 'Y' INTO l_ext_site
668: FROM DUAL
669: WHERE EXISTS ( SELECT 1
670: FROM per_all_vacancies vac ,
671: per_recruitment_activity_for praf ,
672: per_recruitment_activities pra ,