Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_GR_YTD_ORIG |
SELECT GRYTDORG.ROWID ROW_ID
, GRYTDORG.YTDOR_ID
, GRYTDORG.ORIGINATION_ID
, GRYTDORG.ORIGINAL_SSN
, GRYTDORG.ORIGINAL_NAME_CD
, GRYTDORG.ATTEND_PELL_ID
, GRYTDORG.ED_USE
, GRYTDORG.INST_CROSS_REF_CODE
, GRYTDORG.ACTION_CODE
, GRYTDORG.ACCPT_AWD_AMT
, GRYTDORG.ACCPT_DISB_DT1
, GRYTDORG.ACCPT_DISB_DT2
, GRYTDORG.ACCPT_DISB_DT3
, GRYTDORG.ACCPT_DISB_DT4
, GRYTDORG.ACCPT_DISB_DT5
, GRYTDORG.ACCPT_DISB_DT6
, GRYTDORG.ACCPT_DISB_DT7
, GRYTDORG.ACCPT_DISB_DT8
, GRYTDORG.ACCPT_DISB_DT9
, GRYTDORG.ACCPT_DISB_DT10
, GRYTDORG.ACCPT_DISB_DT11
, GRYTDORG.ACCPT_DISB_DT12
, GRYTDORG.ACCPT_DISB_DT13
, GRYTDORG.ACCPT_DISB_DT14
, GRYTDORG.ACCPT_DISB_DT15
, GRYTDORG.ACCPT_ENRL_DT
, GRYTDORG.ACCPT_LOW_TUT_FLG
, GRYTDORG.ACCPT_VER_STAT_FLG
, GRYTDORG.ACCPT_INCR_PELL_CD
, GRYTDORG.ACCPT_TRAN_NUM
, GRYTDORG.ACCPT_EFC
, GRYTDORG.ACCPT_SEC_EFC
, GRYTDORG.ACCPT_ACAD_CAL
, GRYTDORG.ACCPT_PYMT_METHOD
, GRYTDORG.ACCPT_COA
, GRYTDORG.ACCPT_ENRL_STAT
, GRYTDORG.ACCPT_WKS_INST_PYMT
, GRYTDORG.WK_INST_TIME_CALC_PYMT
, GRYTDORG.ACCPT_WKS_ACAD
, GRYTDORG.ACCPT_CR_ACAD_YR
, GRYTDORG.INST_SEQ_NUM
, GRYTDORG.SCH_FULL_TIME_PELL
, GRYTDORG.STUD_NAME
, GRYTDORG.SSN
, GRYTDORG.STUD_DOB
, GRYTDORG.CPS_VER_SEL_CD
, GRYTDORG.YTD_DISB_AMT
, GRYTDORG.BATCH_ID
, GRYTDORG.PROCESS_DATE
, GRYTDORG.CREATED_BY
, GRYTDORG.CREATION_DATE
, GRYTDORG.LAST_UPDATED_BY
, GRYTDORG.LAST_UPDATE_DATE
, GRYTDORG.LAST_UPDATE_LOGIN
, GRYTDORG.REQUEST_ID
, GRYTDORG.PROGRAM_APPLICATION_ID
, GRYTDORG.PROGRAM_ID
, GRYTDORG.PROGRAM_UPDATE_DATE
, GRYTDORG.ORG_ID
, GRYTDORG.CI_CAL_TYPE
, GRYTDORG.CI_SEQUENCE_NUMBER
FROM IGF_GR_YTD_ORIG_ALL GRYTDORG
WHERE NVL ( GRYTDORG.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)