HRMS - Applicant Detail: Address (2)

Description
Categories: Discoverer
Columns: Address Line1, Address Line2, Address Line3, Address Style, Address Type, Addr Comments, Addr Date From, Addr Date To, Applicant Name, Business Group Name ...
This workbook reports on the detail of your applicants
Owner: SYSADMIN (System Administrator)
Identifier: HRIPRAPD
SELECT HRFG_ADDRESSES.ADDRESS_LINE1, HRFG_ADDRESSES.ADDRESS_LINE2, HRFG_ADDRESSES.ADDRESS_LINE3, HRFG_ADDRESSES.ADDRESS_STYLE, HRFG_ADDRESSES.ADDRESS_TYPE, HRFG_ADDRESSES.ADDR_COMMENTS, HRFG_ADDRESSES.ADDR_DATE_FROM, HRFG_ADDRESSES.ADDR_DATE_TO, HRFG_APPLICANT_DETAILS.APPLICANT_NAME, HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME, HRFG_ADDRESSES.CITY, HRFG_ADDRESSES.POSTAL_CODE, HRFG_ADDRESSES.PRIMARY_FLAG, HRFG_ADDRESSES.REGION_1, HRFG_ADDRESSES.REGION_2
FROM HRFG_ADDRESSES HRFG_ADDRESSES, HRFG_APPLICANT_DETAILS HRFG_APPLICANT_DETAILS WHERE 1=1 AND ((HRFG_APPLICANT_DETAILS.PERSON_ID = HRFG_ADDRESSES.PERSON_ID ) ) AND (HRFG_APPLICANT_DETAILS.APPLICATION_START_DATE IS NOT NULL  ) AND (:effective_date BETWEEN HRFG_ADDRESSES.ADDR_DATE_FROM AND NVL(HRFG_ADDRESSES.ADDR_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