APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on PER_ALL_VACANCIES

Line 225: , per_all_vacancies vac

221: , vac.name
222: , vac.recruiter_id
223: , vac.primary_posting_id
224: FROM irc_search_criteria isc
225: , per_all_vacancies vac
226: , hr_locations_all loc
227: WHERE isc.object_type = 'VACANCY'
228: AND isc.object_id = vac.vacancy_id
229: AND vac.location_id = loc.location_id (+)

Line 695: ( p_vacancy_id per_all_vacancies.vacancy_id%type )

691: -- |--------------------< get_int_rec_site >-------------------------------|
692: -- -------------------------------------------------------------------------
693: --
694: FUNCTION get_int_rec_site
695: ( p_vacancy_id per_all_vacancies.vacancy_id%type )
696: RETURN varchar2
697: IS
698: l_int_site irc_all_recruiting_sites.internal%type;
699: BEGIN

Line 704: FROM per_all_vacancies vac ,

700:
701: SELECT 'Y' INTO l_int_site
702: FROM DUAL
703: WHERE EXISTS ( SELECT 1
704: FROM per_all_vacancies vac ,
705: per_recruitment_activity_for praf ,
706: per_recruitment_activities pra ,
707: irc_all_recruiting_sites site
708: WHERE

Line 730: ( p_vacancy_id per_all_vacancies.vacancy_id%type )

726: -- |--------------------< get_ext_rec_site >-------------------------------|
727: -- -------------------------------------------------------------------------
728: --
729: FUNCTION get_ext_rec_site
730: ( p_vacancy_id per_all_vacancies.vacancy_id%type )
731: RETURN varchar2
732: IS
733: l_ext_site irc_all_recruiting_sites.external%type;
734: BEGIN

Line 739: FROM per_all_vacancies vac ,

735:
736: SELECT 'Y' INTO l_ext_site
737: FROM DUAL
738: WHERE EXISTS ( SELECT 1
739: FROM per_all_vacancies vac ,
740: per_recruitment_activity_for praf ,
741: per_recruitment_activities pra ,
742: irc_all_recruiting_sites site
743: WHERE

Line 908: , per_all_vacancies vac

904: , irc_posting_contents_tl ipc_tl
905: , per_recruitment_activity_for praf
906: , per_recruitment_activities pra
907: , irc_all_recruiting_sites site
908: , per_all_vacancies vac
909: , hr_locations_all loc
910: WHERE icrit_vac.object_type = ''VACANCY''
911: AND icrit_vac.object_id = vac.vacancy_id
912: AND vac.location_id = loc.location_id(+)