[Home] [Help]
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
Name |
ROW_ID |
PERSONNEL_OFFICE_ID |
DESCRIPTION |
GROUPBOX_ID |
GROUPBOX_NAME |
PERSON_ID |
FULL_NAME |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |