[Home] [Help]
| Product: | IGF - Financial Aid (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT LAR.ROWID ROW_ID
, LAR.LOAN_ID LOAN_ID
, LAR.AWARD_ID AWARD_ID
, LAR.SEQ_NUM SEQ_NUM
, LAR.LOAN_NUMBER LOAN_NUMBER
, LAR.LOAN_PER_BEGIN_DATE LOAN_PER_BEGIN_DATE
, LAR.LOAN_PER_END_DATE LOAN_PER_END_DATE
, LAR.LOAN_STATUS LOAN_STATUS
, LAR.LOAN_STATUS_DATE LOAN_STATUS_DATE
, LAR.LOAN_CHG_STATUS LOAN_CHG_STATUS
, LAR.LOAN_CHG_STATUS_DATE LOAN_CHG_STATUS_DATE
, LAR.ACTIVE ACTIVE
, LAR.ACTIVE_DATE ACTIVE_DATE
, LAR.BORW_DETRM_CODE BORW_DETRM_CODE
, LAR.CREATED_BY CREATED_BY
, LAR.CREATION_DATE CREATION_DATE
, LAR.LAST_UPDATED_BY LAST_UPDATED_BY
, LAR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAR.REQUEST_ID REQUEST_ID
, LAR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, LAR.PROGRAM_ID PROGRAM_ID
, LAR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAR.ORG_ID ORG_ID
, LAR.LEGACY_RECORD_FLAG LEGACY_RECORD_FLAG
, LAR.EXTERNAL_LOAN_ID_TXT EXTERNAL_LOAN_ID_TXT
FROM IGF_SL_LOANS_ALL LAR
WHERE NVL (LAR.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)