Product: | IGF - Financial Aid |
---|---|
Description: | Award Distribution Plan Teaching Periods |
Implementation/DBA Data: | APPS.IGF_AW_DP_TEACH_PRDS_V |
SELECT ADTEACH.ROWID
, ADTEACH.ADTEACH_ID
, ADTEACH.ADTERMS_ID
, ADTEACH.TP_CAL_TYPE
, ADTEACH.TP_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, CA.START_DT
, CA.END_DT
, ADTEACH.TP_PERCT_NUM
, ADTEACH.DATE_OFFSET_CD
, ADTEACH.ATTENDANCE_TYPE_CODE
, ATD.DESCRIPTION
, ADTEACH.CREDIT_POINTS_NUM
, ADTEACH.CREATED_BY
, ADTEACH.CREATION_DATE
, ADTEACH.LAST_UPDATED_BY
, ADTEACH.LAST_UPDATE_DATE
, ADTEACH.LAST_UPDATE_LOGIN
FROM IGF_AW_DP_TEACH_PRDS ADTEACH
, IGS_CA_INST CA
, IGS_EN_ATD_TYPE ATD
WHERE CA.CAL_TYPE = ADTEACH.TP_CAL_TYPE
AND CA.SEQUENCE_NUMBER = ADTEACH.TP_SEQUENCE_NUMBER
AND ADTEACH.ATTENDANCE_TYPE_CODE = ATD.ATTENDANCE_TYPE (+)