Product: | IGF - Financial Aid |
---|---|
Description: | FA126_3102439_CS_DP2.doc - Obsolete |
Implementation/DBA Data: | APPS.IGF_AP_FA_SETUP |
SELECT FAS.ROWID ROW_ID
, FAS.FAO_ID FAO_ID
, FAS.FAO_NAME FAO_NAME
, FAS.PARTY_ID PARTY_ID
, FAS.OPE_ID OPE_ID
, FAS.PELL_ID PELL_ID
, FAS.DUNS_ID DUNS_ID
, FAS.CSS_ID CSS_ID
, FAS.STATE_AGENCY_ID STATE_AGENCY_ID
, FAS.CAMPUS_ID CAMPUS_ID
, FAS.CRS_ID CRS_ID
, FAS.LOW_DEFAULT LOW_DEFAULT
, FAS.QA_SCHOOL QA_SCHOOL
, FAS.EXPERIMENTAL EXPERIMENTAL
, FAS.GRADE_CALC_OPT GRADE_CALC_OPT
, FAS.CREATED_BY CREATED_BY
, FAS.CREATION_DATE CREATION_DATE
, FAS.LAST_UPDATED_BY LAST_UPDATED_BY
, FAS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FAS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FAS.ORG_ID ORG_ID
, FAS.FAS_ID FAS_ID
, FAS.FSEOG_MATCH_MTHD FSEOG_MATCH_MTHD
, FAS.FSEOG_FED_PCT FSEOG_FED_PCT
, FAS.FSEOG_WAIVER FSEOG_WAIVER
, FAS.DEST_NUM DEST_NUM
FROM IGF_AP_FA_SETUP_ALL FAS
WHERE NVL (FAS.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)