Product: | IGF - Financial Aid (Obsolete) |
---|---|
Description: | FA125_3160568_CS_DP1.doc - Obsolete |
Implementation/DBA Data: | Not implemented in this database |
SELECT TMAP.ROW_ID
, TMAP.TMAP_ID
, TMAP.EXT_TERM
, TMAP.CI_CAL_TYPE
, TMAP.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, TMAP.LD_CAL_TYPE
, TMAP.LD_SEQUENCE_NUMBER
, LD.ALTERNATE_CODE
, LD.START_DT
, LD.END_DT
, TMAP.ACTIVE
, TMAP.CREATED_BY
, TMAP.CREATION_DATE
, TMAP.LAST_UPDATED_BY
, TMAP.LAST_UPDATE_DATE
, TMAP.LAST_UPDATE_LOGIN
FROM IGF_AW_TERM_MAP TMAP
, IGS_CA_INST CI
, IGS_CA_INST LD
WHERE TMAP.LD_CAL_TYPE = LD.CAL_TYPE
AND TMAP.LD_SEQUENCE_NUMBER =LD.SEQUENCE_NUMBER
AND TMAP.CI_CAL_TYPE = CI.CAL_TYPE
AND TMAP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER