[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 |