Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_CL_RESP_R4 |
SELECT ROWID
, CLRP1_ID
, LOAN_NUMBER
, FED_STAFFORD_LOAN_DEBT
, FED_SLS_DEBT
, HEAL_DEBT
, PERKINS_DEBT
, OTHER_DEBT
, CRDT_UNDR_DIFFT_NAME
, BORW_GROSS_ANNUAL_SAL
, BORW_OTHER_INCOME
, STUDENT_MAJOR
, INT_RATE_OPT
, REPAYMENT_OPT_CODE
, STUD_MTH_HOUSING_PYMT
, STUD_MTH_CRDTCARD_PYMT
, STUD_MTH_AUTO_PYMT
, STUD_MTH_ED_LOAN_PYMT
, STUD_MTH_OTHER_PYMT
, COSNR_1_LAST_NAME
, COSNR_1_FIRST_NAME
, COSNR_1_MIDDLE_NAME
, COSNR_1_SSN
, COSNR_1_CITIZENSHIP
, COSNR_1_ADDR_LINE1
, COSNR_1_ADDR_LINE2
, COSNR_1_CITY
, COSNR_1_STATE
, COSNR_1_ZIP
, COSNR_1_ZIP_SUFFIX
, COSNR_1_PHONE
, COSNR_1_SIG_CODE
, COSNR_1_GROSS_ANL_SAL
, COSNR_1_OTHER_INCOME
, COSNR_1_FORN_POSTAL_CODE
, COSNR_1_FORN_PHONE_PREFIX
, COSNR_1_DOB
, COSNR_1_LICENSE_STATE
, COSNR_1_LICENSE_NUM
, COSNR_1_RELATIONSHIP_TO
, COSNR_1_YEARS_AT_ADDR
, COSNR_1_MTH_HOUSING_PYMT
, COSNR_1_MTH_CRDTCARD_PYMT
, COSNR_1_MTH_AUTO_PYMT
, COSNR_1_MTH_ED_LOAN_PYMT
, COSNR_1_MTH_OTHER_PYMT
, COSNR_1_CRDT_AUTH_CODE
, COSNR_2_LAST_NAME
, COSNR_2_FIRST_NAME
, COSNR_2_MIDDLE_NAME
, COSNR_2_SSN
, COSNR_2_CITIZENSHIP
, COSNR_2_ADDR_LINE1
, COSNR_2_ADDR_LINE2
, COSNR_2_CITY
, COSNR_2_STATE
, COSNR_2_ZIP
, COSNR_2_ZIP_SUFFIX
, COSNR_2_PHONE
, COSNR_2_SIG_CODE
, COSNR_2_GROSS_ANL_SAL
, COSNR_2_OTHER_INCOME
, COSNR_2_FORN_POSTAL_CODE
, COSNR_2_FORN_PHONE_PREFIX
, COSNR_2_DOB
, COSNR_2_LICENSE_STATE
, COSNR_2_LICENSE_NUM
, COSNR_2_RELATIONSHIP_TO
, COSNR_2_YEARS_AT_ADDR
, COSNR_2_MTH_HOUSING_PYMT
, COSNR_2_MTH_CRDTCARD_PYMT
, COSNR_2_MTH_AUTO_PYMT
, COSNR_2_MTH_ED_LOAN_PYMT
, COSNR_2_MTH_OTHER_PYMT
, COSNR_2_CRDT_AUTH_CODE
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OTHER_LOAN_AMT
, ALT_LAYOUT_OWNER_CODE_TXT
, ALT_LAYOUT_IDENTI_CODE_TXT
, STUDENT_SCHOOL_PHONE_TXT
, FIRST_CSGNR_ELEC_SIGN_FLAG
, SECOND_CSGNR_ELEC_SIGN_FLAG
FROM IGF_SL_CL_RESP_R4_ALL CLRP4
WHERE NVL(CLRP4.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)