Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds Direct Stafford Loan Promissory Notes |
Implementation/DBA Data: | APPS.IGFFV_DL_STAFFORD_PROM_NOTES |
SELECT SPNOTE.BATCH_SEQ_NUM
, SPNOTE.LOAN_NUMBER
, SPNOTE.S_SSN
, SPNOTE.S_FIRST_NAME
, SPNOTE.S_LAST_NAME
, SPNOTE.S_MIDDLE_NAME
, SPNOTE.S_DATE_OF_BIRTH
, SPNOTE.S_LICENSE_NUM
, SPNOTE.S_LICENSE_STATE
, SPNOTE.S_PERMT_ADDR1
, SPNOTE.S_PERMT_ADDR2
, SPNOTE.S_PERMT_CITY
, SPNOTE.S_PERMT_STATE
, SPNOTE.S_PERMT_ZIP
, SPNOTE.S_EMAIL_ADDR
, SPNOTE.S_PHONE
, SPNOTE.STATUS
, LOANS.LOAN_PER_BEGIN_DATE
, LOANS.LOAN_PER_END_DATE
, '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING'
, AWARDS.ACCEPTED_AMT
, FMAST.DESCRIPTION
, AWDY.ALTERNATE_CODE
, SPNOTE.LOAN_ID
, SPNOTE.PERSON_ID
, SPNOTE.PNSP_ID
, SPNOTE.CREATED_BY
, SPNOTE.CREATION_DATE
, SPNOTE.LAST_UPDATED_BY
, SPNOTE.LAST_UPDATE_DATE
FROM IGF_SL_DL_PNOTE_S_P_ALL SPNOTE
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWARDS
, IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL AWDY
WHERE SPNOTE.LOAN_ID = LOANS.LOAN_ID
AND LOANS.AWARD_ID = AWARDS.AWARD_ID
AND AWARDS.FUND_ID = FMAST.FUND_ID
AND FMAST.CI_CAL_TYPE = AWDY.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = AWDY.SEQUENCE_NUMBER WITH READ ONLY