Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_DL_MANIFEST |
SELECT PNMN.ROWID
, PNMN.PNMN_ID
, PNMN.BATCH_SEQ_NUM
, PNMN.LOAN_ID
, PNMN.LOAN_NUMBER
, PNMN.B_SSN
, PNMN.B_FIRST_NAME
, PNMN.B_LAST_NAME
, PNMN.B_MIDDLE_NAME
, PNMN.STATUS
, PNMN.ORG_ID
, PNMN.CREATED_BY
, PNMN.CREATION_DATE
, PNMN.LAST_UPDATED_BY
, PNMN.LAST_UPDATE_DATE
, PNMN.LAST_UPDATE_LOGIN
, PNMN.REQUEST_ID
, PNMN.PROGRAM_APPLICATION_ID
, PNMN.PROGRAM_ID
, PNMN.PROGRAM_UPDATE_DATE
FROM IGF_SL_DL_MANIFEST_ALL PNMN
WHERE NVL(PNMN.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)