Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_DL_PNOTE_P_P |
SELECT PNPP.ROWID
, PNPP.PNPP_ID
, PNPP.BATCH_SEQ_NUM
, PNPP.LOAN_ID
, PNPP.LOAN_NUMBER
, PNPP.LOAN_AMT_OFFERED
, PNPP.LOAN_AMT_ACCEPTED
, PNPP.LOAN_PER_BEGIN_DATE
, PNPP.LOAN_PER_END_DATE
, PNPP.PERSON_ID
, PNPP.S_SSN
, PNPP.S_FIRST_NAME
, PNPP.S_LAST_NAME
, PNPP.S_MIDDLE_NAME
, PNPP.S_DATE_OF_BIRTH
, PNPP.S_CITIZENSHIP_STATUS
, PNPP.S_ALIEN_REG_NUMBER
, PNPP.S_LICENSE_NUM
, PNPP.S_LICENSE_STATE
, PNPP.S_PERMT_ADDR1
, PNPP.S_PERMT_ADDR2
, PNPP.S_PERMT_CITY
, PNPP.S_PERMT_STATE
, PNPP.S_PERMT_PROVINCE
, PNPP.S_PERMT_COUNTY
, PNPP.S_PERMT_COUNTRY
, PNPP.S_PERMT_ZIP
, PNPP.S_EMAIL_ADDR
, PNPP.S_PHONE
, PNPP.P_PERSON_ID
, PNPP.P_SSN
, PNPP.P_LAST_NAME
, PNPP.P_FIRST_NAME
, PNPP.P_MIDDLE_NAME
, PNPP.P_DATE_OF_BIRTH
, PNPP.P_CITIZENSHIP_STATUS
, PNPP.P_ALIEN_REG_NUM
, PNPP.P_LICENSE_NUM
, PNPP.P_LICENSE_STATE
, PNPP.P_PERMT_ADDR1
, PNPP.P_PERMT_ADDR2
, PNPP.P_PERMT_CITY
, PNPP.P_PERMT_STATE
, PNPP.P_PERMT_PROVINCE
, PNPP.P_PERMT_COUNTY
, PNPP.P_PERMT_COUNTRY
, PNPP.P_PERMT_ZIP
, PNPP.P_EMAIL_ADDR
, PNPP.P_PHONE
, PNPP.STATUS
, PNPP.ORG_ID
, PNPP.CREATED_BY
, PNPP.CREATION_DATE
, PNPP.LAST_UPDATED_BY
, PNPP.LAST_UPDATE_DATE
, PNPP.LAST_UPDATE_LOGIN
, PNPP.REQUEST_ID
, PNPP.PROGRAM_APPLICATION_ID
, PNPP.PROGRAM_ID
, PNPP.PROGRAM_UPDATE_DATE
FROM IGF_SL_DL_PNOTE_P_P_ALL PNPP
WHERE NVL(PNPP.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)