Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_DL_SETUP_V |
SELECT DLSET.ROW_ID ROW_ID
, DLSET.DLSET_ID DLSET_ID
, DLSET.CI_CAL_TYPE CI_CAL_TYPE
, DLSET.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CI.START_DT CI_START_DT
, CI.END_DT CI_END_DT
, CI.ALTERNATE_CODE CI_ALTERNATE_CODE
, DLSET.SCHOOL_ID SCHOOL_ID
, DLSET.ORIG_FEE_PERCT_STAFFORD ORIG_FEE_PERCT_STAFFORD
, DLSET.ORIG_FEE_PERCT_PLUS ORIG_FEE_PERCT_PLUS
, DLSET.INT_REBATE INT_REBATE
, DLSET.PNOTE_PRINT_IND PNOTE_PRINT_IND
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PNOTE_PRINT_IND'
, DLSET.PNOTE_PRINT_IND) PNOTE_PRINT_IND_DESC
, DLSET.PNOTE_PRINT_COPIES PNOTE_PRINT_COPIES
, DLSET.ACC_NOTE_FOR_DISB ACC_NOTE_FOR_DISB
, DLSET.AFFIRMATION_REQD AFFIRMATION_REQD
, DLSET.INTERVIEW_REQD INTERVIEW_REQD
, DLSET.DISCLOSURE_PRINT_IND DISCLOSURE_PRINT_IND
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_DISCLOSURE_PRINT_IND'
, DLSET.DISCLOSURE_PRINT_IND) DISCLOSURE_PRINT_DESC
, DLSET.SPECIAL_SCHOOL SPECIAL_SCHOOL
, DLSET.DL_VERSION DL_VERSION
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_DL_VERSION'
, DLSET.DL_VERSION) DL_VERSION_DESC
, DLSET.CREATED_BY CREATED_BY
, DLSET.CREATION_DATE CREATION_DATE
, DLSET.LAST_UPDATED_BY LAST_UPDATED_BY
, DLSET.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DLSET.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DLSET.RESPONSE_OPTION_CODE RESPONSE_OPTION_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_RESP_OPTIONS'
, DLSET.RESPONSE_OPTION_CODE)
, DLSET.FUNDING_METHOD FUNDING_METHOD
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_FUNDING_METHODS'
, DLSET.FUNDING_METHOD)
FROM IGF_SL_DL_SETUP DLSET
, IGS_CA_INST CI
WHERE DLSET.CI_CAL_TYPE = CI.CAL_TYPE
AND DLSET.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER