[Home] [Help]
View: IGF_GR_TUITION_FEES_V
Product: | IGF - Financial Aid |
Description: | Stores the start and end range amounts of low tuition fee codes |
Implementation/DBA Data: |
APPS.IGF_GR_TUITION_FEES_V
|
View Text
SELECT TUFEE.ROWID
, TUFEE. LT_FEES_CODE
, TUFEE.MIN_RANGE_AMT
, TUFEE.MAX_RANGE_AMT
, TUFEE.CAL_TYPE
, TUFEE.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, TUFEE.CREATED_BY
, TUFEE.CREATION_DATE
, TUFEE.LAST_UPDATED_BY
, TUFEE.LAST_UPDATE_DATE
, TUFEE.LAST_UPDATE_LOGIN
FROM IGF_GR_TUITION_FEES TUFEE
, IGS_CA_INST CI
WHERE TUFEE.CAL_TYPE = CI.CAL_TYPE
AND TUFEE.SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
Columns
Name |
ROW_ID |
LT_FEES_CODE |
MIN_RANGE_AMT |
MAX_RANGE_AMT |
CAL_TYPE |
SEQUENCE_NUMBER |
START_DT |
END_DT |
ALTERNATE_CODE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |