Product: | IGF - Financial Aid |
---|---|
Description: | Base view for the entity that holds Student Work Study Award Details |
Implementation/DBA Data: | APPS.IGFBV_STUDENT_FWS_AWAD_DETAILS |
SELECT DISB.DISB_GROSS_AMT
, DISB.DISB_ACCEPTED_AMT
, DISB.LD_CAL_TYPE
, DISB.LD_SEQUENCE_NUMBER
, DISB.NOTIFICATION_SENT
, DISB.NOTIFICATION_DATE
, (NVL(DISB.DISB_ACCEPTED_AMT
, 0) - NVL(DISB.DISB_PAID_AMT
, 0)) REMAINING_AMOUNT
, DISB.DISB_PAID_AMT
, DECODE( NVL(DISB.DISB_ACCEPTED_AMT
, 0)
, 0
, 0
, ROUND(NVL(DISB.DISB_PAID_AMT
, 0) * 100/ DISB.DISB_ACCEPTED_AMT)) PROGRESS_TWDS_LMT
, DISB.AUTH_DATE
, FABASE.CI_CAL_TYPE
, FABASE.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, DISB.AUTH_ID
, FABASE.PERSON_ID
, FABASE.BASE_ID
, FMAST.FUND_ID
, DISB.AWARD_ID
, DISB.DISB_NUM
, DISB.CREATED_BY
, DISB.CREATION_DATE
, DISB.LAST_UPDATED_BY
, DISB.LAST_UPDATE_DATE
FROM IGF_AW_AWD_DISB_ALL DISB
, IGF_AW_AWARD_ALL AWD
, IGF_AP_FA_BASE_REC_ALL FABASE
, IGF_AW_FUND_MAST_ALL FMAST
, IGF_AW_FUND_CAT_ALL FCAT
, IGS_CA_INST_ALL CI
WHERE DISB.AWARD_ID = AWD.AWARD_ID
AND FABASE.BASE_ID = AWD.BASE_ID
AND FMAST.FUND_ID = AWD.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND CI.CAL_TYPE = DISB.LD_CAL_TYPE
AND CI.SEQUENCE_NUMBER = DISB.LD_SEQUENCE_NUMBER
AND FCAT.FED_FUND_CODE = 'FWS' WITH READ ONLY