View: IGS_EN_ELGB_OVR_V

Product:	IGS - Student System
Description:	Describes the Enrollment Category Eligibility Validation Override step Details
Implementation/DBA Data:	APPS.IGS_EN_ELGB_OVR_V

View Text

SELECT EOA.ROWID ROW_ID
, EOA.ELGB_OVERRIDE_ID
, EOA.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, L1.MEANING
, PP.DATE_OF_BIRTH
, EOA.CAL_TYPE
, EOA.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI. ALTERNATE_CODE
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD (CI.CAL_TYPE
, CI.SEQUENCE_NUMBER)
, 1
, 10)
, EOA.ORG_ID
, EOA.CREATED_BY
, EOA.CREATION_DATE
, EOA.LAST_UPDATED_BY
, EOA.LAST_UPDATE_DATE
, EOA.LAST_UPDATE_LOGIN
, CI.DESCRIPTION CI_DESCRIPTION
FROM IGS_EN_ELGB_OVR EOA
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, FND_LOOKUP_VALUES L1
, IGS_CA_INST CI
WHERE EOA.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)
AND PP.GENDER = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'HZ_GENDER'
AND L1.LANGUAGE(+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID(+) = 222
AND L1.SECURITY_GROUP_ID(+) = 0
AND L1.ENABLED_FLAG = 'Y'
AND (EOA.CAL_TYPE = CI.CAL_TYPE
AND EOA.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER)

Columns