HRMS - Applicant Detail: Qualification

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_QUALIFICATIONS.AWARDED_DATE, HRFG_QUALIFICATIONS.AWARDING_BODY, HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME, HRFG_QUALIFICATIONS.GRADE_ATTAINED, HRFG_QUALIFICATIONS.LICENSE_EXPIRY_DATE, HRFG_QUALIFICATIONS.LICENSE_NUMBER, HRFG_QUALIFICATIONS.LICENSE_RESTRICTIONS, HRFG_QUALIFICATIONS.METHOD_OF_REIMBURSEMENT, HRFG_QUALIFICATIONS.PROJECTED_COMPLETION_DATE, HRFG_QUALIFICATIONS.QUALIFICATION_END_DATE, HRFG_QUALIFICATIONS.QUALIFICATION_START_DATE, HRFG_QUALIFICATIONS.QUALIFICATION_STATUS, HRFG_QUALIFICATIONS.QUALIFICATION_TITLE, HRFG_QUALIFICATIONS.TRAINING_COMPLETED_UNITS
FROM HRFG_APPLICANT_DETAILS HRFG_APPLICANT_DETAILS, HRFG_QUALIFICATIONS HRFG_QUALIFICATIONS
WHERE ( ( HRFG_APPLICANT_DETAILS.PERSON_ID = HRFG_QUALIFICATIONS.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 ) AND ( ( (  ( HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME = :business_group_name OR :business_group_name IS NULL  )  ) ) ) AND ( ( (  ( HRFG_APPLICANT_DETAILS.APPLICANT_NAME = :applicant_name OR :applicant_name IS NULL  )  ) ) )
ORDER BY HRFG_APPLICANT_DETAILS.APPLICANT_NAME ASC
Parameter Name SQL text Validation
Applicant Name
 
LOV
Business Group Name
 
LOV
Effective Date
 
Date