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

Copy

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