Product: | IGF - Financial Aid |
---|---|
Description: | Holds Awards that are published to Student Self-Service |
Implementation/DBA Data: | APPS.IGF_AW_SS_AWD_V |
SELECT AWD.AWARD_ID
, AWD.FUND_ID
, AWD.BASE_ID
, AWD.OFFERED_AMT
, AWD.ACCEPTED_AMT
, AWD.PAID_AMT
, AWD.PACKAGING_TYPE
, AWD.BATCH_ID
, AWD.MANUAL_UPDATE
, AWD.RULES_OVERRIDE
, AWD.AWARD_DATE
, AWD.AWARD_STATUS
, AWD.ATTRIBUTE_CATEGORY
, AWD.ATTRIBUTE1
, AWD.ATTRIBUTE2
, AWD.ATTRIBUTE3
, AWD.ATTRIBUTE4
, AWD.ATTRIBUTE5
, AWD.ATTRIBUTE6
, AWD.ATTRIBUTE7
, AWD.ATTRIBUTE8
, AWD.ATTRIBUTE9
, AWD.ATTRIBUTE10
, AWD.ATTRIBUTE11
, AWD.ATTRIBUTE12
, AWD.ATTRIBUTE13
, AWD.ATTRIBUTE14
, AWD.ATTRIBUTE15
, AWD.ATTRIBUTE16
, AWD.ATTRIBUTE17
, AWD.ATTRIBUTE18
, AWD.ATTRIBUTE19
, AWD.ATTRIBUTE20
, AWD.CREATED_BY
, AWD.CREATION_DATE
, AWD.LAST_UPDATED_BY
, AWD.LAST_UPDATE_DATE
, AWD.LAST_UPDATE_LOGIN
, AWD.PROGRAM_APPLICATION_ID
, AWD.PROGRAM_ID
, AWD.PROGRAM_UPDATE_DATE
, AWD.REQUEST_ID
, AWD.ORG_ID
, AWD.RVSN_ID
, AWD.ALT_PELL_SCHEDULE
, AWD.AWARD_NUMBER_TXT
, AWD.LEGACY_RECORD_FLAG
, AWD.ADPLANS_ID
, AWD.LOCK_AWARD_FLAG
, AWD.APP_TRANS_NUM_TXT
, AWD.AWD_PROC_STATUS_CODE
, AWD.NOTIFICATION_STATUS_CODE
, AWD.NOTIFICATION_STATUS_DATE
, AWD.PUBLISH_IN_SS_FLAG
, APRD.AWARD_PRD_CD
, APRD.CI_CAL_TYPE
, APRD.CI_SEQUENCE_NUMBER
, HZ.PARTY_NUMBER
, CA.ALTERNATE_CODE
, APRD.AWARD_PRD_DESC
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_AWARD_PRD APRD
, IGF_AP_FA_BASE_REC_ALL FA
, HZ_PARTIES HZ
, IGS_CA_INST_ALL CA
WHERE FA.BASE_ID = AWD.BASE_ID
AND FA.CI_CAL_TYPE = APRD.CI_CAL_TYPE
AND FA.CI_SEQUENCE_NUMBER = APRD.CI_SEQUENCE_NUMBER
AND FA.PERSON_ID = HZ.PARTY_ID
AND CA.CAL_TYPE = FA.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = FA.CI_SEQUENCE_NUMBER
AND NVL (AWD.PUBLISH_IN_SS_FLAG
, 'N') = 'Y'
AND NOT EXISTS ( SELECT LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
FROM IGF_AW_AWD_DISB_ALL DISB
WHERE DISB.AWARD_ID = AWD.AWARD_ID MINUS SELECT LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
FROM IGF_AW_AWD_PRD_TERM APT
WHERE APRD.CI_CAL_TYPE = APT.CI_CAL_TYPE
AND APRD.CI_SEQUENCE_NUMBER = APT.CI_SEQUENCE_NUMBER
AND APRD.AWARD_PRD_CD = APT.AWARD_PRD_CD) ORDER BY APRD.AWARD_PRD_CD
, AWD.AWARD_ID
, APRD.CI_CAL_TYPE
, APRD.CI_SEQUENCE_NUMBER