[Home] [Help]
| Product: | IGF - Financial Aid (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DISTINCT IAS.ROWID
, IAS.QUESTION_ID
, IAS.QUESTION
, IAS.ENABLED
, IAS.ORG_ID
, IAS.CI_CAL_TYPE
, IAS.CI_SEQUENCE_NUMBER
, CALREL.AW_START_DT
, CALREL.AW_END_DT
, CALREL.AW_ALTERNATE_CODE
, IAS.CREATED_BY
, IAS.CREATION_DATE
, IAS.LAST_UPDATED_BY
, IAS.LAST_UPDATE_DATE
, IAS.LAST_UPDATE_LOGIN
, IAS.APPLICATION_CODE
, IAS.APPLICATION_NAME
, IAS.ACTIVE_FLAG
, IAS.ANSWER_TYPE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_ANSWER_TYPE'
, IAS.ANSWER_TYPE_CODE) ANSWER_TYPE_DESC
, IAS.DESTINATION_TXT
, IAS.LD_CAL_TYPE
, IAS.LD_SEQUENCE_NUMBER
, DECODE(IAS.LD_CAL_TYPE
, NULL
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_ALL_TERMS'
, IAS.ALL_TERMS_FLAG)
, CALREL.LD_ALTERNATE_CODE)LD_ALTERNATE_CODE
, IAS.ALL_TERMS_FLAG
, IAS.OVERRIDE_EXIST_ANT_DATA_FLAG
, IAS.REQUIRED_FLAG
, IAS.MINIMUM_VALUE_NUM
, IAS.MAXIMUM_VALUE_NUM
, IAS.MINIMUM_DATE
, IAS.MAXIMIUM_DATE
, IAS.LOOKUP_CODE
, IAS.HINT_TXT
FROM IGF_AP_APPL_SETUP_ALL IAS
, IGF_AW_AWD_LD_CAL_V CALREL
WHERE CALREL.AW_CAL_TYPE = IAS.CI_CAL_TYPE
AND CALREL.AW_SEQUENCE_NUMBER = IAS.CI_SEQUENCE_NUMBER
AND ((CALREL.LD_CAL_TYPE = IAS.LD_CAL_TYPE
AND CALREL.LD_SEQUENCE_NUMBER = IAS.LD_SEQUENCE_NUMBER) OR (IAS.ALL_TERMS_FLAG = 'Y') OR (IAS.ALL_TERMS_FLAG IS NULL
AND IAS.LD_CAL_TYPE IS NULL) )