FND Design Data [Home] [Help]

View: HR_ATH_EMPLOYER_V

Product: PER - Human Resources
Description: View to support Authoria Integration
Implementation/DBA Data: ViewAPPS.HR_ATH_EMPLOYER_V
View Text

SELECT TO_CHAR(BUSINESS_GROUP_ID) EMPLOYER_ID
, NAME NAME
, DATE_FROM START_DATE
, NVL(DATE_TO
, TO_DATE('12/31/4712'
, 'MM/DD/YYYY')) END_DATE
FROM PER_BUSINESS_GROUPS

Columns

Name
EMPLOYER_ID
NAME
START_DATE
END_DATE