Product: | IGF - Financial Aid |
---|---|
Description: | Base view for the entity that holds Direct Plus Loan Promissory Notes |
Implementation/DBA Data: | APPS.IGFBV_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
, 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 WITH READ ONLY