HRMS - Applicant Detail: Competence

Description
Categories: Discoverer
This workbook reports on the detail of your applicants
Owner: SYSADMIN (System Administrator)
Identifier: HRIPRAPD
SELECT HRFG_APPLICANT_DETAILS.APPLICANT_NAME, HRFG_COMPETENCE_PROFILES.BUSINESS_GROUP_NAME, HRFG_COMPETENCE_PROFILES.CERTIFICATION_DATE, HRFG_COMPETENCE_PROFILES.CERTIFICATION_METHOD, HRFG_COMPETENCE_PROFILES.COMPETENCE_NAME, HRFG_COMPETENCE_PROFILES.DATE_FROM, HRFG_COMPETENCE_PROFILES.DATE_TO, HRFG_COMPETENCE_PROFILES.NEXT_REVIEW_DATE, HRFG_COMPETENCE_PROFILES.PROFICIENCY_LEVEL, HRFG_COMPETENCE_PROFILES.PROFICIENCY_RATING_SOURCE
FROM HRFG_APPLICANT_DETAILS HRFG_APPLICANT_DETAILS, HRFG_COMPETENCE_PROFILES HRFG_COMPETENCE_PROFILES
WHERE 1=1 AND ( ( HRFG_APPLICANT_DETAILS.PERSON_ID = HRFG_COMPETENCE_PROFILES.PERSON_ID ) ) AND ( HRFG_APPLICANT_DETAILS.APPLICATION_START_DATE IS NOT NULL  ) AND ( :effective_date BETWEEN HRFG_APPLICANT_DETAILS.RECORD_START_DATE AND HRFG_APPLICANT_DETAILS.RECORD_END_DATE )    
ORDER BY HRFG_APPLICANT_DETAILS.APPLICANT_NAME ASC
Parameter Name SQL text Validation
Applicant Name
HRFG_APPLICANT_DETAILS.APPLICANT_NAME = :applicant_name
LOV
Business Group Name
HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME = :business_group_name
LOV
Effective Date
 
Date