VIEW: APPS.GHR_POIS_V

Source

View Text - Preformatted

SELECT POI.ROWID ROW_ID , POI.PERSONNEL_OFFICE_ID , POI.DESCRIPTION ,POI.HR_OFFICE_NAME ,POI.HR_OFFICE_ADD1 , POI.HR_OFFICE_ADD2 , POI.HR_OFFICE_ADD3 , POI.HR_OFFICE_ADD4, POI.GROUPBOX_ID , GBX.NAME GROUPBOX_NAME , POI.PERSON_ID , PPF.FULL_NAME , POI.BEN_CONTACT_NAME, POI.CONTACT_PHONE, 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 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/01/1951', 'dd/mm/yyyy')) and NVL(ppf.effective_end_date,TO_DATE ('31/12/4712', 'dd/mm/yyyy'))

View Text - HTML Formatted

SELECT POI.ROWID ROW_ID
, POI.PERSONNEL_OFFICE_ID
, POI.DESCRIPTION
, POI.HR_OFFICE_NAME
, POI.HR_OFFICE_ADD1
, POI.HR_OFFICE_ADD2
, POI.HR_OFFICE_ADD3
, POI.HR_OFFICE_ADD4
, POI.GROUPBOX_ID
, GBX.NAME GROUPBOX_NAME
, POI.PERSON_ID
, PPF.FULL_NAME
, POI.BEN_CONTACT_NAME
, POI.CONTACT_PHONE
, 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
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/01/1951'
, 'DD/MM/YYYY'))
AND NVL(PPF.EFFECTIVE_END_DATE
, TO_DATE ('31/12/4712'
, 'DD/MM/YYYY'))