Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_AW_AWD_FRML_DET |
SELECT FMDET.ROWID
, FMDET.FORMULA_CODE
, FMDET.CI_CAL_TYPE
, FMDET.CI_SEQUENCE_NUMBER
, FMDET.SEQ_NO
, FMDET.FUND_ID
, FMDET.MIN_AWARD_AMT
, FMDET.MAX_AWARD_AMT
, FMDET.REPLACE_FC
, FMDET.CREATED_BY
, FMDET.CREATION_DATE
, FMDET.LAST_UPDATED_BY
, FMDET.LAST_UPDATE_DATE
, FMDET.LAST_UPDATE_LOGIN
, FMDET.ORG_ID
, FMDET.PE_GROUP_ID
, FMDET.ADPLANS_ID
, FMDET.LOCK_AWARD_FLAG
FROM IGF_AW_AWD_FRML_DET_ALL FMDET
WHERE NVL (FMDET.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)