Product: | IGF - Financial Aid |
---|---|
Description: | Stores the relation between Cost of Attendance Code and Load Calendar |
Implementation/DBA Data: | APPS.IGF_AW_COA_LD_V |
SELECT COALD.ROW_ID
, COALD.COALD_ID
, COALD.COA_CODE
, COALD.CI_CAL_TYPE
, COALD.CI_SEQUENCE_NUMBER
, COALD.LD_CAL_TYPE
, COALD.LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE
, LOAD.START_DT
, LOAD.END_DT
, COALD.LD_PERCT
, COALD.CREATED_BY
, COALD.CREATION_DATE
, COALD.LAST_UPDATED_BY
, COALD.LAST_UPDATE_DATE
, COALD.LAST_UPDATE_LOGIN
FROM IGF_AW_COA_LD COALD
, IGS_CA_INST LOAD
WHERE LOAD.CAL_TYPE = COALD.LD_CAL_TYPE
AND LOAD.SEQUENCE_NUMBER = COALD.LD_SEQUENCE_NUMBER