View: IGSFV_APPL_REVIEW_GROUP_EVALTR

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGSFV_APPL_REVIEW_GROUP_EVALTR

View Text

SELECT ARE.REVGR_EVALUATOR_ID
, ARE.APPL_REVPROF_REVGR_ID
, ARG.REVPROF_REVGR_CD
, ARG.REVPROF_REVGR_NAME
, ARE.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, ARE.EVALUATION_SEQUENCE
, '_LA:ARE.PROGRAM_APPROVER_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ARE.CREATED_BY
, ARE.CREATION_DATE
, ARE.LAST_UPDATED_BY
, ARE.LAST_UPDATE_DATE
FROM IGS_AD_RVGR_EVALTR ARE
, IGS_AD_APL_RPRF_RGR ARG
, HZ_PERSON_PROFILES PP
, HZ_PARTIES P
WHERE ARE.APPL_REVPROF_REVGR_ID = ARG.APPL_REVPROF_REVGR_ID
AND ARE.PERSON_ID = PP.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE) WITH READ ONLY

Columns