VIEW: APPS.IGF_GR_PELL_SETUP_V

Source

View Text - Preformatted

SELECT PELL.ROW_ID, PELL.PELL_SEQ_ID, PELL.REP_PELL_ID, PELL.CI_CAL_TYPE, PELL.CI_SEQUENCE_NUMBER, CI.ALTERNATE_CODE, CI.START_DT, CI.END_DT, NULL, null, null, PELL.INST_CROSS_REF_CODE, PELL.ACADEMIC_CAL, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_ACAD_CAL', PELL.ACADEMIC_CAL) ACAD_CAL_DESC, PELL.PAYMENT_METHOD, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_PAYMENT_METHOD', PELL.PAYMENT_METHOD) PYMT_METHOD_DESC, 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.FUNDING_METHOD, PELL.USE_CENSUS_DTS, PELL.LOW_TUTION_FEE, PELL.ALT_COA_LIMIT, PELL.CREATED_BY, PELL.CREATION_DATE, PELL.LAST_UPDATED_BY, PELL.LAST_UPDATE_DATE, PELL.LAST_UPDATE_LOGIN, PELL.EFC_MAX, PELL.PELL_ALT_EXP_MAX, PELL.COURSE_CD, PELL.VERSION_NUMBER, PSV.TITLE, PELL.PAYMENT_PERIODS_NUM , PELL.ENR_BEFORE_TS_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_PELL_CALC_ENR_TYPE',PELL.ENR_BEFORE_TS_CODE) ENR_BEFORE_TS_CODE_DESC, PELL.ENR_IN_MT_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_PELL_CALC_ENR_TYPE',PELL.ENR_IN_MT_CODE) ENR_IN_MT_CODE_DESC, ENR_AFTER_TC_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_PELL_CALC_ENR_TYPE',ENR_AFTER_TC_CODE) ENR_AFTER_TC_CODE_DESC, PELL.REP_ENTITY_ID_TXT, PELL.RESPONSE_OPTION_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_RESP_OPTIONS',PELL.RESPONSE_OPTION_CODE), IGF_AW_GEN.LOOKUP_DESC('IGF_SL_FUNDING_METHODS',PELL.FUNDING_METHOD), PELL.TERM_START_OFFSET_NUM FROM IGF_GR_PELL_SETUP PELL, IGS_CA_INST CI, IGS_PS_VER PSV WHERE PELL.CI_CAL_TYPE = CI.CAL_TYPE AND PELL.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND PELL.COURSE_CD = PSV.COURSE_CD(+) AND PELL.VERSION_NUMBER = PSV.VERSION_NUMBER(+)

View Text - HTML Formatted

SELECT PELL.ROW_ID
, PELL.PELL_SEQ_ID
, PELL.REP_PELL_ID
, PELL.CI_CAL_TYPE
, PELL.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, NULL
, NULL
, NULL
, PELL.INST_CROSS_REF_CODE
, PELL.ACADEMIC_CAL
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_ACAD_CAL'
, PELL.ACADEMIC_CAL) ACAD_CAL_DESC
, PELL.PAYMENT_METHOD
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_PAYMENT_METHOD'
, PELL.PAYMENT_METHOD) PYMT_METHOD_DESC
, 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.FUNDING_METHOD
, PELL.USE_CENSUS_DTS
, PELL.LOW_TUTION_FEE
, PELL.ALT_COA_LIMIT
, PELL.CREATED_BY
, PELL.CREATION_DATE
, PELL.LAST_UPDATED_BY
, PELL.LAST_UPDATE_DATE
, PELL.LAST_UPDATE_LOGIN
, PELL.EFC_MAX
, PELL.PELL_ALT_EXP_MAX
, PELL.COURSE_CD
, PELL.VERSION_NUMBER
, PSV.TITLE
, PELL.PAYMENT_PERIODS_NUM
, PELL.ENR_BEFORE_TS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_PELL_CALC_ENR_TYPE'
, PELL.ENR_BEFORE_TS_CODE) ENR_BEFORE_TS_CODE_DESC
, PELL.ENR_IN_MT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_PELL_CALC_ENR_TYPE'
, PELL.ENR_IN_MT_CODE) ENR_IN_MT_CODE_DESC
, ENR_AFTER_TC_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_PELL_CALC_ENR_TYPE'
, ENR_AFTER_TC_CODE) ENR_AFTER_TC_CODE_DESC
, PELL.REP_ENTITY_ID_TXT
, PELL.RESPONSE_OPTION_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_RESP_OPTIONS'
, PELL.RESPONSE_OPTION_CODE)
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_FUNDING_METHODS'
, PELL.FUNDING_METHOD)
, PELL.TERM_START_OFFSET_NUM
FROM IGF_GR_PELL_SETUP PELL
, IGS_CA_INST CI
, IGS_PS_VER PSV
WHERE PELL.CI_CAL_TYPE = CI.CAL_TYPE
AND PELL.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND PELL.COURSE_CD = PSV.COURSE_CD(+)
AND PELL.VERSION_NUMBER = PSV.VERSION_NUMBER(+)