Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_CL_RESP_R8 |
SELECT SLRESPR8.ROWID ROW_ID
, SLRESPR8.CLRP1_ID
, SLRESPR8.CLRP8_ID
, SLRESPR8.DISB_DATE
, SLRESPR8.DISB_GROSS_AMT
, SLRESPR8.ORIG_FEE
, SLRESPR8.GUARANTEE_FEE
, SLRESPR8.NET_DISB_AMT
, SLRESPR8.DISB_HOLD_REL_IND
, SLRESPR8.DISB_STATUS
, SLRESPR8.GUARNT_FEE_PAID
, SLRESPR8.ORIG_FEE_PAID
, SLRESPR8.RESP_RECORD_STATUS
, SLRESPR8.CREATED_BY
, SLRESPR8.CREATION_DATE
, SLRESPR8.LAST_UPDATED_BY
, SLRESPR8.LAST_UPDATE_DATE
, SLRESPR8.LAST_UPDATE_LOGIN
, SLRESPR8.REQUEST_ID
, SLRESPR8.PROGRAM_APPLICATION_ID
, SLRESPR8.PROGRAM_ID
, SLRESPR8.PROGRAM_UPDATE_DATE
, SLRESPR8.ORG_ID
, SLRESPR8.LAYOUT_OWNER_CODE_TXT
, SLRESPR8.LAYOUT_VERSION_CODE_TXT
, SLRESPR8.RECORD_CODE_TXT
, SLRESPR8.DIRECT_TO_BORR_FLAG
FROM IGF_SL_CL_RESP_R8_ALL SLRESPR8
WHERE NVL (SLRESPR8.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)