[Home] [Help]
114: , isc.location_id
115: , p_seeker_details.show_jobs_since
116: , per.current_employee_flag
117: FROM
118: irc_search_criteria isc
119: , per_all_people_f per
120: WHERE isc.object_type in ( 'PERSON' ,'WPREF')
121: AND isc.object_id = p_seeker_details.person_id
122: AND isc.use_for_matching = 'Y'
217: , vac.name
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
811: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
812: RAISE e_no_base_url;
813: END IF;
814:
815: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');
816:
817: --
818: -- ***************************************************************************
819: -- Inner SQL to match the Job Seeker criteria to Vacancies
824: , ipc_tl.job_title
825: , ipc_tl.name
826: , icrit_vac.object_id
827: FROM
828: irc_search_criteria icrit_vac
829: , irc_posting_contents ipc
830: , irc_posting_contents_tl ipc_tl
831: , per_recruitment_activity_for praf
832: , per_recruitment_activities pra
1374: l_proc VARCHAR2(30) default ' get_suitable_seekers_for_vac';
1375: BEGIN
1376: hr_utility.set_location('Entering'||l_proc, 10);
1377: --
1378: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');
1379: --
1380: if (p_candidacy_age>0) then
1381: l_date_registered:=trunc(sysdate)-p_candidacy_age;
1382: else
1392: l_sql :=' SELECT DISTINCT
1393: ppf.full_name
1394: , ppf.person_id
1395: FROM
1396: irc_search_criteria icrit
1397: , per_all_people_f ppf
1398: , irc_posting_contents_tl ipc_tl
1399: , hr_locations_all loc
1400: , irc_notification_preferences inp