VIEW: APPS.HR_ATH_EMPGROUP_V

Source

View Text - Preformatted

SELECT TO_CHAR(o.organization_id) employee_groupid ,o.name name ,o.date_from start_date ,nvl(o.date_to,to_date('12/31/4712','mm/dd/yyyy')) end_date FROM hr_organization_units o ,hr_organization_information o3 WHERE o.organization_id = o3.organization_id and o3.org_information_context ||'' = 'CLASS'and o3.org_information1 = 'HR_ORG' and o3.org_information2 = 'Y' and o.internal_external_flag = 'INT'

View Text - HTML Formatted

SELECT TO_CHAR(O.ORGANIZATION_ID) EMPLOYEE_GROUPID
, O.NAME NAME
, O.DATE_FROM START_DATE
, NVL(O.DATE_TO
, TO_DATE('12/31/4712'
, 'MM/DD/YYYY')) END_DATE
FROM HR_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O3
WHERE O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O3.ORG_INFORMATION_CONTEXT ||'' = 'CLASS'AND O3.ORG_INFORMATION1 = 'HR_ORG'
AND O3.ORG_INFORMATION2 = 'Y'
AND O.INTERNAL_EXTERNAL_FLAG = 'INT'