View: IGF_SE_EARNINGS_SUMMARY_V

Product:	IGF - Financial Aid
Description:	The entity is used to display the computed information about students funds payment/disbursement details. Thiswill be used by Student Employment to display computed figures for the fund payment and its percentage disbursement with respect t
Implementation/DBA Data:	APPS.IGF_SE_EARNINGS_SUMMARY_V

View Text

SELECT BASE_ID
, FUND_ID
, LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
, LD_ALTERNATE_CODE
, AWARD_AMOUNT
, EARNINGS_TILL_DATE
, (AWARD_AMOUNT - EARNINGS_TILL_DATE) REMAINING_AMOUNT
, (ROUND(EARNINGS_TILL_DATE/AWARD_AMOUNT) * 100) PROGRESS_TO_LIMIT
, NULL NOTIFICATION_SENT
, NULL NOTIFICATION_DATE
, NULL AUTH_ID
, NULL AUTH_DATE
FROM (SELECT AWD.BASE_ID BASE_ID
, AWD.FUND_ID FUND_ID
, AWDISB.LD_CAL_TYPE LD_CAL_TYPE
, AWDISB.LD_SEQUENCE_NUMBER LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE LD_ALTERNATE_CODE
, NVL(DECODE(SUM(NVL(AWDISB.DISB_ACCEPTED_AMT
, 0))
, 0
, SUM(NVL(AWDISB.DISB_GROSS_AMT
, 0))
, SUM(NVL(AWDISB.DISB_ACCEPTED_AMT
, 0)))
, 0) AWARD_AMOUNT
, SUM (NVL (AWDISB.DISB_PAID_AMT
, 0)) EARNINGS_TILL_DATE
, NULL NOTIFICATION_SENT
, NULL NOTIFICATION_DATE
, NULL AUTH_ID
, NULL AUTH_DATE
FROM IGF_AW_AWARD_V AWD
, IGF_AW_AWD_DISB AWDISB
, IGS_CA_INST LOAD
WHERE AWD.AWARD_ID =AWDISB.AWARD_ID
AND LOAD.CAL_TYPE = AWDISB.LD_CAL_TYPE
AND LOAD.SEQUENCE_NUMBER= AWDISB.LD_SEQUENCE_NUMBER
AND AWD.FED_FUND_CODE ='FWS' GROUP BY AWD.BASE_ID
, AWD.FUND_ID
, AWDISB.LD_CAL_TYPE
, AWDISB.LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE )

Columns