VIEW: APPS.IGSFV_STDNT_PAST_HIST

Source

View Text - Preformatted

SELECT aph.PAST_HISTORY_ID, aph.YEARS_OF_STUDY, aph.SUBJECT_ID, cc.NAME, cc.DESCRIPTION, aph.HONORS, aph.PERSON_ID, p.PARTY_NUMBER, pp.PERSON_NAME, aph.CREATED_BY, aph.CREATION_DATE, aph.LAST_UPDATED_BY, aph.LAST_UPDATE_DATE FROM IGS_AD_PAST_HISTORY_ALL aph, IGS_AD_CODE_CLASSES cc, HZ_PARTIES p, HZ_PERSON_PROFILES pp WHERE aph.SUBJECT_ID = cc.code_id AND aph.PERSON_ID = p.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

View Text - HTML Formatted

SELECT APH.PAST_HISTORY_ID
, APH.YEARS_OF_STUDY
, APH.SUBJECT_ID
, CC.NAME
, CC.DESCRIPTION
, APH.HONORS
, APH.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, APH.CREATED_BY
, APH.CREATION_DATE
, APH.LAST_UPDATED_BY
, APH.LAST_UPDATE_DATE
FROM IGS_AD_PAST_HISTORY_ALL APH
, IGS_AD_CODE_CLASSES CC
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
WHERE APH.SUBJECT_ID = CC.CODE_ID
AND APH.PERSON_ID = P.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