Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_GR_PELL_SETUP |
SELECT PELL.ROWID
, PELL.PELL_SEQ_ID
, PELL.CI_CAL_TYPE
, PELL.CI_SEQUENCE_NUMBER
, PELL.REP_PELL_ID
, NULL
, NULL
, NULL
, PELL.USE_CENSUS_DTS
, PELL.FUNDING_METHOD
, PELL.INST_CROSS_REF_CODE
, PELL.LOW_TUTION_FEE
, PELL.ACADEMIC_CAL
, PELL.PAYMENT_METHOD
, PELL.WK_INST_TIME_CALC_PYMT
, PELL.WK_INT_TIME_PRG_DEF_YR
, PELL.CR_CLK_HRS_PRDS_SCH_YR
, PELL.CR_CLK_HRS_ACAD_YR
, PELL.ALT_COA_LIMIT
, PELL.CREATED_BY
, PELL.CREATION_DATE
, PELL.LAST_UPDATED_BY
, PELL.LAST_UPDATE_DATE
, PELL.LAST_UPDATE_LOGIN
, PELL.ORG_ID
, PELL.EFC_MAX
, PELL.PELL_ALT_EXP_MAX
, PELL.COURSE_CD
, PELL.VERSION_NUMBER
, PELL.PAYMENT_PERIODS_NUM
, PELL.ENR_BEFORE_TS_CODE
, PELL.ENR_IN_MT_CODE
, PELL.ENR_AFTER_TC_CODE
, PELL.REP_ENTITY_ID_TXT
, PELL.RESPONSE_OPTION_CODE
, PELL.TERM_START_OFFSET_NUM
FROM IGF_GR_PELL_SETUP_ALL PELL
WHERE NVL (PELL.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)