Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_DL_LOR_RESP |
SELECT DLLORRESP.ROWID ROW_ID
, DLLORRESP.LOR_RESP_NUM
, DLLORRESP.DBTH_ID
, DLLORRESP.ORIG_BATCH_ID
, DLLORRESP.LOAN_NUMBER
, DLLORRESP.ORIG_ACK_DATE
, DLLORRESP.ORIG_STATUS_FLAG
, DLLORRESP.ORIG_REJECT_REASONS
, DLLORRESP.PNOTE_STATUS
, DLLORRESP.PNOTE_ID
, DLLORRESP.PNOTE_ACCEPT_AMT
, DLLORRESP.LOAN_AMOUNT_ACCEPTED
, DLLORRESP.STATUS
, DLLORRESP.CREATED_BY
, DLLORRESP.CREATION_DATE
, DLLORRESP.LAST_UPDATED_BY
, DLLORRESP.LAST_UPDATE_DATE
, DLLORRESP.LAST_UPDATE_LOGIN
, DLLORRESP.REQUEST_ID
, DLLORRESP.PROGRAM_APPLICATION_ID
, DLLORRESP.PROGRAM_ID
, DLLORRESP.PROGRAM_UPDATE_DATE
, DLLORRESP.ORG_ID
, DLLORRESP.ELEC_MPN_IND
FROM IGF_SL_DL_LOR_RESP_ALL DLLORRESP
WHERE NVL (DLLORRESP.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)