View: GHR_POIS_V

Product:	GHR - US Federal Human Resources
Description:	GHR_POIS_V is based on secure view PER_PEOPLE_V and used by POI form.
Implementation/DBA Data:	APPS.GHR_POIS_V

View Text

SELECT POI.ROWID ROW_ID
, POI.PERSONNEL_OFFICE_ID
, POI.DESCRIPTION
, POI.GROUPBOX_ID
, GBX.NAME GROUPBOX_NAME
, POI.PERSON_ID
, PPF.FULL_NAME
, POI.CREATION_DATE
, POI.CREATED_BY
, POI.LAST_UPDATE_LOGIN
, POI.LAST_UPDATED_BY
, POI.LAST_UPDATE_DATE
FROM GHR_POIS POI
, GHR_GROUPBOXES GBX
, PER_PEOPLE_F PPF
FROM GHR_POIS POI
, GHR_GROUPBOXES GBX
WHERE POI.GROUPBOX_ID = GBX.GROUPBOX_ID(+)
AND POI.PERSON_ID = PPF.PERSON_ID(+)
AND SYSDATE BETWEEN NVL(PPF.EFFECTIVE_START_DATE
, TO_DATE ('01/001/11951'
, 'DD/MMM/YYYYY'))
AND NVL(PPF.EFFECTIVE_END_DATE
, TO_DATE ('31/112/44712'
, 'DD/MMM/YYYYY'))

Columns