APPS.IGFFV_DL_PLUS_PROM_NOTES
[Home] [Help]
| Product: | IGF - Financial Aid |
|---|---|
| Description: | Full View for the Entity that holds Direct Plus Loan Promissory Notes |
| Implementation/DBA Data: |
APPS.IGFFV_DL_PLUS_PROM_NOTES
|
SELECT PPNOTE.BATCH_SEQ_NUM
, PPNOTE.LOAN_NUMBER
, PPNOTE.LOAN_AMT_OFFERED
, PPNOTE.LOAN_AMT_ACCEPTED
, PPNOTE.LOAN_PER_BEGIN_DATE
, PPNOTE.LOAN_PER_END_DATE
, PPNOTE.S_SSN
, PPNOTE.S_FIRST_NAME
, PPNOTE.S_LAST_NAME
, PPNOTE.S_MIDDLE_NAME
, PPNOTE.S_DATE_OF_BIRTH
, '_LA:PPNOTE.S_CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CITIZENSHIP_STAT:MEANING'
, PPNOTE.S_ALIEN_REG_NUMBER
, PPNOTE.S_LICENSE_NUM
, PPNOTE.S_LICENSE_STATE
, PPNOTE.S_PERMT_ADDR1
, PPNOTE.S_PERMT_ADDR2
, PPNOTE.S_PERMT_CITY
, PPNOTE.S_PERMT_STATE
, PPNOTE.S_PERMT_PROVINCE
, PPNOTE.S_PERMT_COUNTY
, PPNOTE.S_PERMT_COUNTRY
, PPNOTE.S_PERMT_ZIP
, PPNOTE.S_EMAIL_ADDR
, PPNOTE.S_PHONE
, PPNOTE.P_SSN
, PPNOTE.P_FIRST_NAME
, PPNOTE.P_LAST_NAME
, PPNOTE.P_MIDDLE_NAME
, PPNOTE.P_DATE_OF_BIRTH
, '_LA:PPNOTE.P_CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CITIZENSHIP_STAT:MEANING'
, PPNOTE.P_ALIEN_REG_NUM
, PPNOTE.P_LICENSE_NUM
, PPNOTE.P_LICENSE_STATE
, PPNOTE.P_PERMT_ADDR1
, PPNOTE.P_PERMT_ADDR2
, PPNOTE.P_PERMT_CITY
, PPNOTE.P_PERMT_STATE
, PPNOTE.P_PERMT_PROVINCE
, PPNOTE.P_PERMT_COUNTY
, PPNOTE.P_PERMT_COUNTRY
, PPNOTE.P_PERMT_ZIP
, PPNOTE.P_EMAIL_ADDR
, PPNOTE.P_PHONE
, PPNOTE.STATUS
, '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING'
, FMAST.DESCRIPTION
, AWDY.ALTERNATE_CODE
, PPNOTE.LOAN_ID
, PPNOTE.PERSON_ID
, PPNOTE.P_PERSON_ID
, PPNOTE.PNPP_ID
, PPNOTE.CREATED_BY
, PPNOTE.CREATION_DATE
, PPNOTE.LAST_UPDATED_BY
, PPNOTE.LAST_UPDATE_DATE
FROM IGF_SL_DL_PNOTE_P_P_ALL PPNOTE
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWARDS
, IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL AWDY
WHERE PPNOTE.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