Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_DL_PNOTE_P_P_V |
SELECT PNPPV.PNPP_ID
, PNPPV.BATCH_SEQ_NUM
, PNPPV.LOAN_ID
, PNPPV.LOAN_NUMBER
, PNPPV.LOAN_AMT_OFFERED
, PNPPV.LOAN_AMT_ACCEPTED
, PNPPV.LOAN_PER_BEGIN_DATE
, PNPPV.LOAN_PER_END_DATE
, PNPPV.PERSON_ID
, PNPPV.S_SSN
, PNPPV.S_FIRST_NAME
, PNPPV.S_LAST_NAME
, PNPPV.S_MIDDLE_NAME
, PNPPV.S_DATE_OF_BIRTH
, PNPPV.S_CITIZENSHIP_STATUS
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CITIZENSHIP_STAT'
, PNPPV.S_CITIZENSHIP_STATUS)
, PNPPV.S_ALIEN_REG_NUMBER
, PNPPV.S_LICENSE_NUM
, PNPPV.S_LICENSE_STATE
, PNPPV.S_PERMT_ADDR1
, PNPPV.S_PERMT_ADDR2
, PNPPV.S_PERMT_CITY
, PNPPV.S_PERMT_STATE
, PNPPV.S_PERMT_PROVINCE
, PNPPV.S_PERMT_COUNTY
, PNPPV.S_PERMT_COUNTRY
, PNPPV.S_PERMT_ZIP
, PNPPV.S_EMAIL_ADDR
, PNPPV.S_PHONE
, PNPPV.P_PERSON_ID
, PNPPV.P_SSN
, PNPPV.P_LAST_NAME
, PNPPV.P_FIRST_NAME
, PNPPV.P_MIDDLE_NAME
, PNPPV.P_DATE_OF_BIRTH
, PNPPV.P_CITIZENSHIP_STATUS
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CITIZENSHIP_STAT'
, PNPPV.P_CITIZENSHIP_STATUS)
, PNPPV.P_ALIEN_REG_NUM
, PNPPV.P_LICENSE_NUM
, PNPPV.P_LICENSE_STATE
, PNPPV.P_PERMT_ADDR1
, PNPPV.P_PERMT_ADDR2
, PNPPV.P_PERMT_CITY
, PNPPV.P_PERMT_STATE
, PNPPV.P_PERMT_PROVINCE
, PNPPV.P_PERMT_COUNTY
, PNPPV.P_PERMT_COUNTRY
, PNPPV.P_PERMT_ZIP
, PNPPV.P_EMAIL_ADDR
, PNPPV.P_PHONE
, IGF_SL_GEN.GET_DISB_DATE(PNPPV.LOAN_ID
, 1)
, IGF_SL_GEN.GET_DISB_DATE(PNPPV.LOAN_ID
, 2)
, IGF_SL_GEN.GET_DISB_DATE(PNPPV.LOAN_ID
, 3)
, IGF_SL_GEN.GET_DISB_DATE(PNPPV.LOAN_ID
, 4)
, PNPPV.STATUS
, PNPPV.ORG_ID
, PNPPV.CREATED_BY
, PNPPV.CREATION_DATE
, PNPPV.LAST_UPDATED_BY
, PNPPV.LAST_UPDATE_DATE
, PNPPV.LAST_UPDATE_LOGIN
, PNPPV.REQUEST_ID
, PNPPV.PROGRAM_APPLICATION_ID
, PNPPV.PROGRAM_ID
, PNPPV.PROGRAM_UPDATE_DATE
FROM IGF_SL_DL_PNOTE_P_P PNPPV