HRMS - Applicant Detail: Phone

➜ Back to Library
Description
Categories: Discoverer
Columns: Applicant Name, Business Group Name, Phone Number, Phone Type ...
This workbook reports on the detail of your applicants
Owner: SYSADMIN (System Administrator)
Identifier: HRIPRAPD 
SELECT HRFG_APPLICANT_DETAILS.APPLICANT_NAME, HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME, HRFG_PHONES.PHONE_NUMBER, HRFG_PHONES.PHONE_TYPE
FROM HRFG_APPLICANT_DETAILS HRFG_APPLICANT_DETAILS, HRFG_PHONES HRFG_PHONES WHERE 1=1 AND ((HRFG_APPLICANT_DETAILS.PERSON_ID = HRFG_PHONES.PERSON_ID ) ) AND (HRFG_APPLICANT_DETAILS.APPLICATION_START_DATE IS NOT NULL  ) AND (:effective_date BETWEEN HRFG_PHONES.DATE_FROM AND NVL(HRFG_PHONES.DATE_TO,'31-DEC-4712') ) 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
Download
Related Blitz Reports
HRMS - Applicant Detail: Qualification HRMS - Applicant Detail: by Source Type HRMS - Applicant Detail: by Organization HRMS - Applicant Detail: Detail HRMS - Applicant Detail: by Grade HRMS - Applicant Detail: Competence HRMS - Applicant Detail: by Vacancy HRMS - Applicant Detail: by Position HRMS - Applicant Detail: Address
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: