GMS_AWARD_CREDIT_ORG_V
Details
-
Schema: FUSION
-
Object owner: GMS
-
Object type: VIEW
Columns
Name |
---|
ORGANIZATION_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE NAME |
Query
SQL_Statement |
---|
SELECT DISTINCT haof.organization_id, haof.EFFECTIVE_START_DATE, haof.EFFECTIVE_END_DATE , haotl.name FROM HR_ALL_ORGANIZATION_UNITS_F haof, HR_ORGANIZATION_UNITS_F_TL haotl, HR_ORG_UNIT_CLASSIFICATIONS_F ouc WHERE haof.ORGANIZATION_ID = haotl.ORGANIZATION_ID AND haotl.LANGUAGE = USERENV('LANG') AND haotl.EFFECTIVE_START_DATE = haof.EFFECTIVE_START_DATE AND haotl.EFFECTIVE_END_DATE = haof.EFFECTIVE_END_DATE AND haof.ORGANIZATION_ID = ouc.ORGANIZATION_ID AND TRUNC(haof.EFFECTIVE_START_DATE) BETWEEN TRUNC(ouc.EFFECTIVE_START_DATE) AND TRUNC(ouc.EFFECTIVE_END_DATE) AND ouc.classification_code IN ('PA_PROJECT_ORG','DEPARTMENT') AND ouc.STATUS IN ( 'A', 'ACTIVE') AND TRUNC(SYSDATE) BETWEEN TRUNC(haof.EFFECTIVE_START_DATE) AND TRUNC(haof.EFFECTIVE_END_DATE) |