eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGF_AP_APPL_SETUP_V

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.IGF_AP_APPL_SETUP_V

View Text

SELECT DISTINCT IAS.ORG_ID
, IAS.CI_CAL_TYPE
, IAS.CI_SEQUENCE_NUMBER
, CAL.START_DT
, CAL.END_DT
, CAL.ALTERNATE_CODE
, IAS.APPLICATION_CODE
, IAS.APPLICATION_NAME
, IAS.ACTIVE_FLAG FROM IGS_CA_INST CAL
, IGF_AP_APPL_SETUP IAS
WHERE IAS.CI_CAL_TYPE = CAL.CAL_TYPE AND IAS.CI_SEQUENCE_NUMBER = CAL.SEQUENCE_NUMBER

Columns

Name
ORG_ID
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
START_DT
END_DT
AWARD_YEAR
APPLICATION_CODE
APPLICATION_NAME
ACTIVE_FLAG