APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on PER_ALL_VACANCIES

Line 222: , per_all_vacancies vac

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

Line 626: ( p_vacancy_id per_all_vacancies.vacancy_id%type )

622: -- |--------------------< get_int_rec_site >-------------------------------|
623: -- -------------------------------------------------------------------------
624: --
625: FUNCTION get_int_rec_site
626: ( p_vacancy_id per_all_vacancies.vacancy_id%type )
627: RETURN varchar2
628: IS
629: l_int_site irc_all_recruiting_sites.internal%type;
630: BEGIN

Line 635: FROM per_all_vacancies vac ,

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 ,
638: irc_all_recruiting_sites site
639: WHERE

Line 661: ( p_vacancy_id per_all_vacancies.vacancy_id%type )

657: -- |--------------------< get_ext_rec_site >-------------------------------|
658: -- -------------------------------------------------------------------------
659: --
660: FUNCTION get_ext_rec_site
661: ( p_vacancy_id per_all_vacancies.vacancy_id%type )
662: RETURN varchar2
663: IS
664: l_ext_site irc_all_recruiting_sites.external%type;
665: BEGIN

Line 670: FROM per_all_vacancies vac ,

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 ,
673: irc_all_recruiting_sites site
674: WHERE

Line 834: , per_all_vacancies vac

830: , irc_posting_contents_tl ipc_tl
831: , per_recruitment_activity_for praf
832: , per_recruitment_activities pra
833: , irc_all_recruiting_sites site
834: , per_all_vacancies vac
835: , hr_locations_all loc
836: WHERE
837: icrit_vac.object_type = ''VACANCY''
838: AND icrit_vac.object_id = vac.vacancy_id