VIEW: APPS.IRCFV_CANDIDATE_SRCH_CRITERIA

Source

View Text - Preformatted

SELECT par.person_name candidate_name ,isc.search_name search_name ,isc.location location ,isc.distance_to_location distance_to_location ,hr_bis.bis_decode_lookup('YES_NO',isc.employee) suitable_for_employee ,hr_bis.bis_decode_lookup('YES_NO',isc.contractor) suitable_for_contractor ,hr_bis.bis_decode_lookup('IRC_EMP_CAT',isc.employment_category) employment_category ,isc.keywords keywords ,hr_bis.bis_decode_lookup('IRC_TRAVEL_PERCENTAGE', isc.travel_percentage) travel_percentage ,isc.min_salary min_salary ,isc.salary_currency salary_currency ,isc.salary_period salary_period ,hr_bis.bis_decode_lookup('YES_NO',isc.match_competence) match_competence ,hr_bis.bis_decode_lookup('YES_NO',isc.match_qualification) match_qualification ,isc.job_title job_title ,isc.department department ,hr_bis.bis_decode_lookup('IRC_PROFESSIONAL_AREA',isc.professional_area) professional_area ,hr_bis.bis_decode_lookup('IRC_WORK_AT_HOME',isc.work_at_home) work_at_home ,hr_bis.bis_decode_lookup('YES_NO',isc.use_for_matching) use_for_matching ,isc.description description /* flexfields */ ,'_DF:PER:IRC_SEARCH_CRITERIA:isc' ,'_DF:PER:IRC_SEARCH_CRITERIA_DDF:isc' /* system codes */ ,isc.employee suitable_for_employee_code ,isc.contractor suitable_for_contractor_code ,isc.employment_category employment_category_code ,isc.travel_percentage travel_percentage_code ,isc.match_competence match_competence_code ,isc.match_qualification match_qualification_code ,isc.professional_area professional_area_code ,isc.work_at_home work_at_home_code /* system ids */ ,isc.search_criteria_id search_criteria_id ,inp.party_id party_id FROM irc_search_criteria isc, hz_person_profiles par, irc_notification_preferences inp WHERE isc.object_type = 'PERSON' AND isc.object_id = inp.person_id AND inp.party_id = par.party_id AND inp.allow_access = 'Y' AND trunc(sysdate) between NVL(par.effective_start_date, hr_general.start_of_time) and NVL(par.effective_end_date , hr_general.end_of_time) WITH READ ONLY

View Text - HTML Formatted

SELECT PAR.PERSON_NAME CANDIDATE_NAME
, ISC.SEARCH_NAME SEARCH_NAME
, ISC.LOCATION LOCATION
, ISC.DISTANCE_TO_LOCATION DISTANCE_TO_LOCATION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ISC.EMPLOYEE) SUITABLE_FOR_EMPLOYEE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ISC.CONTRACTOR) SUITABLE_FOR_CONTRACTOR
, HR_BIS.BIS_DECODE_LOOKUP('IRC_EMP_CAT'
, ISC.EMPLOYMENT_CATEGORY) EMPLOYMENT_CATEGORY
, ISC.KEYWORDS KEYWORDS
, HR_BIS.BIS_DECODE_LOOKUP('IRC_TRAVEL_PERCENTAGE'
, ISC.TRAVEL_PERCENTAGE) TRAVEL_PERCENTAGE
, ISC.MIN_SALARY MIN_SALARY
, ISC.SALARY_CURRENCY SALARY_CURRENCY
, ISC.SALARY_PERIOD SALARY_PERIOD
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ISC.MATCH_COMPETENCE) MATCH_COMPETENCE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ISC.MATCH_QUALIFICATION) MATCH_QUALIFICATION
, ISC.JOB_TITLE JOB_TITLE
, ISC.DEPARTMENT DEPARTMENT
, HR_BIS.BIS_DECODE_LOOKUP('IRC_PROFESSIONAL_AREA'
, ISC.PROFESSIONAL_AREA) PROFESSIONAL_AREA
, HR_BIS.BIS_DECODE_LOOKUP('IRC_WORK_AT_HOME'
, ISC.WORK_AT_HOME) WORK_AT_HOME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ISC.USE_FOR_MATCHING) USE_FOR_MATCHING
, ISC.DESCRIPTION DESCRIPTION /* FLEXFIELDS */
, '_DF:PER:IRC_SEARCH_CRITERIA:ISC'
, '_DF:PER:IRC_SEARCH_CRITERIA_DDF:ISC' /* SYSTEM CODES */
, ISC.EMPLOYEE SUITABLE_FOR_EMPLOYEE_CODE
, ISC.CONTRACTOR SUITABLE_FOR_CONTRACTOR_CODE
, ISC.EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY_CODE
, ISC.TRAVEL_PERCENTAGE TRAVEL_PERCENTAGE_CODE
, ISC.MATCH_COMPETENCE MATCH_COMPETENCE_CODE
, ISC.MATCH_QUALIFICATION MATCH_QUALIFICATION_CODE
, ISC.PROFESSIONAL_AREA PROFESSIONAL_AREA_CODE
, ISC.WORK_AT_HOME WORK_AT_HOME_CODE /* SYSTEM IDS */
, ISC.SEARCH_CRITERIA_ID SEARCH_CRITERIA_ID
, INP.PARTY_ID PARTY_ID
FROM IRC_SEARCH_CRITERIA ISC
, HZ_PERSON_PROFILES PAR
, IRC_NOTIFICATION_PREFERENCES INP
WHERE ISC.OBJECT_TYPE = 'PERSON'
AND ISC.OBJECT_ID = INP.PERSON_ID
AND INP.PARTY_ID = PAR.PARTY_ID
AND INP.ALLOW_ACCESS = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(PAR.EFFECTIVE_START_DATE
, HR_GENERAL.START_OF_TIME)
AND NVL(PAR.EFFECTIVE_END_DATE
, HR_GENERAL.END_OF_TIME) WITH READ ONLY