VIEW: APPS.HR_ATH_EMPLOYER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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