View: IGFFV_STUDENT_FWS_AWAD_DETAILS

Product:	IGF - Financial Aid
Description:	Full View for the Entity that holds Student Work Study Award Details
Implementation/DBA Data:	APPS.IGFFV_STUDENT_FWS_AWAD_DETAILS

View Text

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
, AWARD_CI.ALTERNATE_CODE
, LOAD_CI.ALTERNATE_CODE
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, HZ.PARTY_NUMBER
, HZ.PERSON_FIRST_NAME
, HZ.PERSON_LAST_NAME
, HZ.PERSON_MIDDLE_NAME
, FABASE.CI_CAL_TYPE
, FABASE.CI_SEQUENCE_NUMBER
, 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 LOAD_CI
, IGS_CA_INST_ALL AWARD_CI
, HZ_PARTIES HZ
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 LOAD_CI.CAL_TYPE = DISB.LD_CAL_TYPE
AND LOAD_CI.SEQUENCE_NUMBER = DISB.LD_SEQUENCE_NUMBER
AND FCAT.FED_FUND_CODE = 'FWS'
AND HZ.PARTY_ID = FABASE.PERSON_ID
AND AWARD_CI.CAL_TYPE = FABASE.CI_CAL_TYPE
AND AWARD_CI.SEQUENCE_NUMBER = FABASE.CI_SEQUENCE_NUMBER WITH READ ONLY

Columns