View: IGF_GR_PELL_RNG_AMT_V

Product:	IGF - Financial Aid
Description:	Shows the cost of attendance ranges for Pell against expected family contribution amounts
Implementation/DBA Data:	APPS.IGF_GR_PELL_RNG_AMT_V

View Text

SELECT CRNGD.ROWID ROW_ID
, CI.ALTERNATE_CODE CI_ALTERNATE_CODE
, CRNGD.ENROLLMENT_STAT ENROLLMENT_STAT
, CRNGD.CI_CAL_TYPE CI_CAL_TYPE
, CRNGD.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CI.START_DT CI_START_DT
, CI.END_DT CI_END_DT
, CRNGD.COA_START COA_START
, CRNGD.COA_END COA_END
, CRNGD.EFC_START EFC_START
, CRNGD.EFC_END EFC_END
, CRNGD.AMOUNT AMOUNT
, CRNGD.CREATED_BY CREATED_BY
, CRNGD.CREATION_DATE CREATION_DATE
, CRNGD.LAST_UPDATED_BY LAST_UPDATED_BY
, CRNGD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CRNGD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGF_GR_PELL_RNG_AMT CRNGD
, IGS_CA_INST CI
WHERE CI.CAL_TYPE = CRNGD.CI_CAL_TYPE
AND CI.SEQUENCE_NUMBER = CRNGD.CI_SEQUENCE_NUMBER

Columns