Product: | IGF - Financial Aid |
---|---|
Description: | Retrives all the award disbursement details for the student employment awards |
Implementation/DBA Data: | APPS.IGF_SE_AWD_DISB_V |
SELECT ADISB.ROWID
, ADISB.AWARD_ID
, ADISB.DISB_NUM
, ADISB.TP_CAL_TYPE
, ADISB.TP_SEQUENCE_NUMBER
, ADISB.DISB_GROSS_AMT
, ADISB.FEE_1
, ADISB.FEE_2
, ADISB.DISB_NET_AMT
, ADISB.DISB_DATE
, ADISB.TRANS_TYPE
, ADISB.ELIG_STATUS
, ADISB.ELIG_STATUS_DATE
, ADISB.AFFIRM_FLAG
, ADISB.HOLD_REL_IND
, ADISB.MANUAL_HOLD_IND
, ADISB.DISB_STATUS
, ADISB.DISB_STATUS_DATE
, ADISB.LATE_DISB_IND
, ADISB.FUND_DIST_MTHD
, ADISB.PREV_REPORTED_IND
, ADISB.FUND_RELEASE_DATE
, ADISB.FUND_STATUS
, ADISB.FUND_STATUS_DATE
, ADISB.FEE_PAID_1
, ADISB.FEE_PAID_2
, ADISB.CHEQUE_NUMBER
, ADISB.CREATED_BY
, ADISB.CREATION_DATE
, ADISB.LAST_UPDATED_BY
, ADISB.LAST_UPDATE_DATE
, ADISB.LAST_UPDATE_LOGIN
, ADISB.REQUEST_ID
, ADISB.PROGRAM_APPLICATION_ID
, ADISB.PROGRAM_ID
, ADISB.PROGRAM_UPDATE_DATE
, ADISB.ORG_ID
, ADISB.LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER
, ADISB.DISB_ACCEPTED_AMT
, ADISB.DISB_PAID_AMT
, ADISB.RVSN_ID
, ADISB.INT_REBATE_AMT
, ADISB.FORCE_DISB
, ADISB.MIN_CREDIT_PTS
, ADISB.DISB_EXP_DT
, ADISB.VERF_ENFR_DT
, NULL
, NULL
, NULL
, NULL
, ADISB.FEE_CLASS
, ADISB.SHOW_ON_BILL
, (NVL(ADISB.DISB_ACCEPTED_AMT
, 0) - NVL(ADISB.DISB_PAID_AMT
, 0)) REMAINING_AMOUNT
, DECODE( NVL(ADISB.DISB_ACCEPTED_AMT
, 0)
, 0
, 0
, ROUND(NVL(ADISB.DISB_PAID_AMT
, 0) * 100/ ADISB.DISB_ACCEPTED_AMT)) PROGRESS_TWDS_LMT
, CILD.ALTERNATE_CODE LD_ALTERNATE_CODE
FROM IGF_AW_AWD_DISB_ALL ADISB
, IGS_CA_INST CILD
WHERE CILD.CAL_TYPE = ADISB.LD_CAL_TYPE
AND CILD.SEQUENCE_NUMBER = ADISB.LD_SEQUENCE_NUMBER