View: IGS_AD_RVGR_EVALTR_V

Product:	IGS - Student System
Description:	View where all Evaluator corresponding to Application Review Profile related information will be recorded.
Implementation/DBA Data:	APPS.IGS_AD_RVGR_EVALTR_V

View Text

SELECT EV.ROWID
, EV.REVGR_EVALUATOR_ID
, EV.APPL_REVPROF_REVGR_ID
, PP.PARTY_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, EV.EVALUATION_SEQUENCE
, EV.PROGRAM_APPROVER_IND
, EV.CREATED_BY
, EV.CREATION_DATE
, EV.LAST_UPDATED_BY
, EV.LAST_UPDATE_DATE
, EV.LAST_UPDATE_LOGIN
FROM IGS_AD_RVGR_EVALTR EV
, HZ_PERSON_PROFILES PP
, HZ_PARTIES P
WHERE P.PARTY_ID = PP.PARTY_ID
AND EV.PERSON_ID = PP.PARTY_ID
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)

Columns