Product: | IGF - Financial Aid |
---|---|
Description: | Shows award details |
Implementation/DBA Data: | APPS.IGF_AW_AWARD_V |
SELECT AWD.ROW_ID ROW_ID
, AWD.AWARD_ID AWARD_ID
, FMAST.CI_CAL_TYPE CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE CI_ALTERNATE_CODE
, CI.START_DT CI_START_DT
, CI.END_DT CI_END_DT
, FMAST.FUND_CODE FUND_CODE
, FTYPE.FUND_TYPE FUND_TYPE
, FCAT.FED_FUND_CODE FED_FUND_CODE
, FCAT.SYS_FUND_TYPE SYS_FUND_TYPE
, AWD.FUND_ID FUND_ID
, FMAST.DESCRIPTION DESCRIPTION
, AWD.BASE_ID BASE_ID
, AWD.OFFERED_AMT OFFERED_AMT
, AWD.ACCEPTED_AMT ACCEPTED_AMT
, AWD.PAID_AMT PAID_AMT
, AWD.PACKAGING_TYPE PACKAGING_TYPE
, AWD.MANUAL_UPDATE MANUAL_UPDATE
, AWD.RULES_OVERRIDE RULES_OVERRIDE
, AWD.BATCH_ID BATCH_ID
, AWD.AWARD_DATE AWARD_DATE
, AWD.AWARD_STATUS AWARD_STATUS
, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_STATUS'
, AWD.AWARD_STATUS) AWARD_STATUS_DESC
, AWD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AWD.ATTRIBUTE1 ATTRIBUTE1
, AWD.ATTRIBUTE2 ATTRIBUTE2
, AWD.ATTRIBUTE3 ATTRIBUTE3
, AWD.ATTRIBUTE4 ATTRIBUTE4
, AWD.ATTRIBUTE5 ATTRIBUTE5
, AWD.ATTRIBUTE6 ATTRIBUTE6
, AWD.ATTRIBUTE7 ATTRIBUTE7
, AWD.ATTRIBUTE8 ATTRIBUTE8
, AWD.ATTRIBUTE9 ATTRIBUTE9
, AWD.ATTRIBUTE10 ATTRIBUTE10
, AWD.ATTRIBUTE11 ATTRIBUTE11
, AWD.ATTRIBUTE12 ATTRIBUTE12
, AWD.ATTRIBUTE13 ATTRIBUTE13
, AWD.ATTRIBUTE14 ATTRIBUTE14
, AWD.ATTRIBUTE15 ATTRIBUTE15
, AWD.ATTRIBUTE16 ATTRIBUTE16
, AWD.ATTRIBUTE17 ATTRIBUTE17
, AWD.ATTRIBUTE18 ATTRIBUTE18
, AWD.ATTRIBUTE19 ATTRIBUTE19
, AWD.ATTRIBUTE20 ATTRIBUTE20
, FCAT.FUND_SOURCE FUND_SOURCE
, FACON.PERSON_ID STUDENT_ID
, FACON.PERSON_ID PERSON_ID
, PE.PARTY_NUMBER PERSON_NUMBER
, PIT.API_PERSON_ID SSN
, PE.PERSON_LAST_NAME||'
, '||PE.PERSON_FIRST_NAME FULL_NAME
, AWD.RVSN_ID RVSN_ID
, RVSN.DESCP REVISION_DESC
, AWD.CREATED_BY CREATED_BY
, AWD.CREATION_DATE CREATION_DATE
, AWD.LAST_UPDATED_BY LAST_UPDATED_BY
, AWD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AWD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AWD.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AWD.PROGRAM_ID PROGRAM_ID
, AWD.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AWD.REQUEST_ID REQUEST_ID
, AWD.ALT_PELL_SCHEDULE
, AWD.LEGACY_RECORD_FLAG
, AWD.AWARD_NUMBER_TXT
, AWD.ADPLANS_ID
, ADPLANS.AWD_DIST_PLAN_CD
, ADPLANS.AWD_DIST_PLAN_CD_DESC
, ADPLANS.DIST_PLAN_METHOD_CODE
, AWD.LOCK_AWARD_FLAG
, AWD.APP_TRANS_NUM_TXT
, FCAT.ALT_LOAN_CODE ALT_LOAN_CODE
, FCAT.ALT_REL_CODE ALT_REL_CODE
, AWD.AWD_PROC_STATUS_CODE
, AWD.NOTIFICATION_STATUS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_NOTIFIC_STAT'
, AWD. NOTIFICATION_STATUS_CODE) NOTIFICATION_STATUS_CODE_DESC
, AWD.NOTIFICATION_STATUS_DATE
, AWD.PUBLISH_IN_SS_FLAG
FROM IGF_AW_AWARD AWD
, IGF_AW_FUND_MAST FMAST
, IGF_AW_FUND_CAT FCAT
, IGF_AW_FUND_TYPE FTYPE
, IGS_CA_INST CI
, IGF_AP_FA_BASE_REC FACON
, ( SELECT API_PERSON_ID
, PE_PERSON_ID
FROM IGS_PE_PERSON_ID_TYP PIT_2
, IGS_PE_ALT_PERS_ID API_2
WHERE API_2.PERSON_ID_TYPE = PIT_2.PERSON_ID_TYPE
AND PIT_2.S_PERSON_ID_TYPE = 'SSN'
AND SYSDATE BETWEEN API_2.START_DT
AND NVL(API_2.END_DT
, SYSDATE) ) PIT
, HZ_PARTIES PE
, IGF_AW_AWD_RVSN_RSN RVSN
, IGF_AW_AWD_DIST_PLANS ADPLANS
WHERE AWD.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND FCAT.FUND_TYPE = FTYPE.FUND_TYPE
AND FMAST.CI_CAL_TYPE = CI.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND AWD.BASE_ID = FACON.BASE_ID
AND PE.PARTY_ID =FACON.PERSON_ID
AND PE.PARTY_ID = PIT.PE_PERSON_ID (+)
AND AWD.RVSN_ID = RVSN.RVSN_ID (+)
AND AWD.ADPLANS_ID = ADPLANS.ADPLANS_ID (+)
AND FMAST.FUND_ID = AWD.FUND_ID