Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_GR_YTD_DISB |
SELECT GRYTDDB.ROWID ROW_ID
, GRYTDDB.YTDDS_ID
, GRYTDDB.ORIGINATION_ID
, GRYTDDB.INST_CROSS_REF_CODE
, GRYTDDB.ACTION_CODE
, GRYTDDB.DISB_REF_NUM
, GRYTDDB.DISB_ACCPT_AMT
, GRYTDDB.DB_CR_FLAG
, GRYTDDB.DISB_DT
, GRYTDDB.PYMT_PRD_START_DT
, GRYTDDB.DISB_BATCH_ID
, GRYTDDB.CREATED_BY
, GRYTDDB.CREATION_DATE
, GRYTDDB.LAST_UPDATED_BY
, GRYTDDB.LAST_UPDATE_DATE
, GRYTDDB.LAST_UPDATE_LOGIN
, GRYTDDB.REQUEST_ID
, GRYTDDB.PROGRAM_APPLICATION_ID
, GRYTDDB.PROGRAM_ID
, GRYTDDB.PROGRAM_UPDATE_DATE
, GRYTDDB.ORG_ID
, GRYTDDB.CI_CAL_TYPE
, GRYTDDB.CI_SEQUENCE_NUMBER
, GRYTDDB.STUDENT_NAME
, GRYTDDB.CURRENT_SSN_TXT
, GRYTDDB.STUDENT_BIRTH_DATE
, GRYTDDB.DISB_PROCESS_DATE
, GRYTDDB.ROUTING_ID_TXT
, GRYTDDB.FIN_AWARD_YEAR_NUM
, GRYTDDB.ATTEND_ENTITY_ID_TXT
, GRYTDDB.DISB_SEQ_NUM
, GRYTDDB.DISB_REL_IND
, GRYTDDB.PREV_DISB_SEQ_NUM
FROM IGF_GR_YTD_DISB_ALL GRYTDDB
WHERE NVL (GRYTDDB.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)