Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_AWD_DISB_LOC |
SELECT AWDL.ROWID ROW_ID
, AWDL.AWARD_ID AWARD_ID
, AWDL.DISB_NUM DISB_NUM
, AWDL.DISB_GROSS_AMT DISB_GROSS_AMT
, AWDL.FEE_1 FEE_1
, AWDL.FEE_2 FEE_2
, AWDL.DISB_NET_AMT DISB_NET_AMT
, AWDL.DISB_DATE DISB_DATE
, AWDL.HOLD_REL_IND HOLD_REL_IND
, AWDL.FEE_PAID_1 FEE_PAID_1
, AWDL.FEE_PAID_2 FEE_PAID_2
, AWDL.CREATED_BY CREATED_BY
, AWDL.CREATION_DATE CREATION_DATE
, AWDL.LAST_UPDATED_BY LAST_UPDATED_BY
, AWDL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AWDL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AWDL.REQUEST_ID REQUEST_ID
, AWDL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AWDL.PROGRAM_ID PROGRAM_ID
, AWDL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AWDL.ORG_ID ORG_ID
FROM IGF_SL_AWD_DISB_LOC_ALL AWDL
WHERE NVL (AWDL.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)