Product: | IGF - Financial Aid |
---|---|
Description: | Stores the Cost of Attendance Objects across load calendars. |
Implementation/DBA Data: | APPS.IGF_AW_CIT_LD_OVERIDE_V |
SELECT CLDO.ROW_ID
, CLDO.CLDO_ID
, CLDO.COA_CODE
, CLDO.CI_CAL_TYPE
, CLDO.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, CLDO.ITEM_CODE
, CLDO.LD_CAL_TYPE
, CLDO.LD_SEQUENCE_NUMBER
, CI_LD.ALTERNATE_CODE
, CI_LD.START_DT
, CI_LD.END_DT
, CLDO.LD_PERCT
, CLDO.CREATED_BY
, CLDO.CREATION_DATE
, CLDO.LAST_UPDATED_BY
, CLDO.LAST_UPDATE_DATE
, CLDO.LAST_UPDATE_LOGIN
FROM IGF_AW_CIT_LD_OVERIDE CLDO
, IGS_CA_INST CI
, IGS_CA_INST CI_LD
WHERE CLDO.CI_CAL_TYPE = CI.CAL_TYPE
AND CLDO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CLDO.LD_CAL_TYPE = CI_LD.CAL_TYPE
AND CLDO.LD_SEQUENCE_NUMBER = CI_LD.SEQUENCE_NUMBER