[Home] [Help]
View: HR_ATH_EMPLOYER_V
Product: | PER - Human Resources |
Description: | View to support Authoria Integration |
Implementation/DBA Data: |
APPS.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 |