HRG_DEV_GOALS_SECURED_LIST_V

Details

• Schema: FUSION

• Object owner: HRG

• Object type: VIEW

Columns

Name
PERSON_ID

Query

SQL_Statement
SELECT PersonDPEO.PERSON_ID FROM PER_ALL_PEOPLE_F PersonDPEO WHERE TRUNC(SYSDATE) BETWEEN PersonDPEO.EFFECTIVE_START_DATE AND PersonDPEO.EFFECTIVE_END_DATE