Product: | IGF - Financial Aid |
---|---|
Description: | Award Years |
Implementation/DBA Data: | APPS.IGF_AP_AWARD_YEAR_V |
SELECT CI.ROW_ID ROW_ID
, CI.CAL_TYPE CAL_TYPE
, CI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CI.START_DT START_DT
, CI.END_DT END_DT
, CI.CAL_STATUS CAL_STATUS
, CI.ALTERNATE_CODE ALTERNATE_CODE
, CI.SUP_CAL_STATUS_DIFFER_IND SUP_CAL_STATUS_DIFFER_IND
, CI.PRIOR_CI_SEQUENCE_NUMBER PRIOR_CI_SEQUENCE_NUMBER
, CI.ORG_ID ORG_ID
, CI.CREATED_BY CREATED_BY
, CI.CREATION_DATE CREATION_DATE
, CI.LAST_UPDATED_BY LAST_UPDATED_BY
, CI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CI.DESCRIPTION CAL_DESCRIPTION
, BM.AWARD_YEAR_STATUS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_YEAR_STATUS'
, BM.AWARD_YEAR_STATUS_CODE)
, BM.PELL_PARTICIPANT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_COD_PARTICIPANT_TYPE'
, BM.PELL_PARTICIPANT_CODE)
, BM.DL_PARTICIPANT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_COD_PARTICIPANT_TYPE'
, BM.DL_PARTICIPANT_CODE)
, BM.PUBLISH_IN_SS_FLAG
FROM IGS_CA_INST CI
, IGF_AP_BATCH_AW_MAP_ALL BM
WHERE BM.CI_CAL_TYPE = CI.CAL_TYPE
AND BM.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER