Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_AW_CORRESP |
SELECT ACORRESP.ROWID
, ACORRESP.CRSP_ID
, ACORRESP.BASE_ID
, ACORRESP.FLAG
, ACORRESP.LINE_NUMBER
, ACORRESP.LINE_DATA
, ACORRESP.CREATED_BY
, ACORRESP. CREATION_DATE
, ACORRESP. LAST_UPDATED_BY
, ACORRESP.LAST_UPDATE_DATE
, ACORRESP. LAST_UPDATE_LOGIN
, ACORRESP. REQUEST_ID
, ACORRESP.PROGRAM_APPLICATION_ID
, ACORRESP.PROGRAM_ID
, ACORRESP.PROGRAM_UPDATE_DATE
, ACORRESP.ORG_ID
FROM IGF_AW_CORRESP_ALL ACORRESP
WHERE NVL ( ACORRESP.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)