Product: | IGF - Financial Aid |
---|---|
Description: | FA125_3160568_CS_DP1.doc - Obsolete |
Implementation/DBA Data: | APPS.IGF_AW_TP_INSTMT_V |
SELECT FINST.ROW_ID
, FINST.FUND_ID
, FINST.FINST_ID
, FINST.LD_CAL_TYPE
, FINST.LD_SEQUENCE_NUMBER
, LD_CAL.ALTERNATE_CODE
, LD_CAL.START_DT
, LD_CAL.END_DT
, FINST.TP_CAL_TYPE
, FINST.TP_SEQUENCE_NUMBER
, TP_CAL.ALTERNATE_CODE
, TP_CAL.START_DT
, TP_CAL.END_DT
, FINST.TP_OFFSET_DA
, FINST.TP_PERCT
, FINST.MIN_CREDIT_PTS
, FINST.CREATED_BY
, FINST.CREATION_DATE
, FINST.LAST_UPDATED_BY
, FINST.LAST_UPDATE_DATE
, FINST.LAST_UPDATE_LOGIN
FROM IGF_AW_TP_INSTMT FINST
, IGS_CA_INST LD_CAL
, IGS_CA_INST TP_CAL
WHERE FINST.LD_CAL_TYPE = LD_CAL.CAL_TYPE
AND FINST.LD_SEQUENCE_NUMBER = LD_CAL.SEQUENCE_NUMBER AND FINST.TP_CAL_TYPE = TP_CAL.CAL_TYPE
AND FINST.TP_SEQUENCE_NUMBER = TP_CAL.SEQUENCE_NUMBER