Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Holds sponsor student relation details |
Implementation/DBA Data: | Not implemented in this database |
SELECT SP.LD_CAL_TYPE
, SP.LD_SEQUENCE_NUMBER
, SP.TOT_SPNSR_AMOUNT
, SP.MIN_CREDIT_POINTS
, SP.MIN_ATTENDANCE_TYPE
, PA.PARTY_NUMBER
, PA.PARTY_NAME
, CI1.START_DT
, CI1.END_DT
, CI1.DESCRIPTION
, CI1.ALTERNATE_CODE
, AP.CI_CAL_TYPE
, AP.CI_SEQUENCE_NUMBER
, CI2.START_DT
, CI2.END_DT
, CI2.DESCRIPTION
, CI2.ALTERNATE_CODE
, AW.FUND_CODE
, AW.DESCRIPTION
, SP.SPNSR_STDNT_ID
, SP.FUND_ID
, SP.BASE_ID
, SP.PERSON_ID
, SP.CREATION_DATE
, SP.CREATED_BY
, SP.LAST_UPDATE_DATE
, SP.LAST_UPDATED_BY
FROM IGF_SP_STDNT_REL_ALL SP
, HZ_PARTIES PA
, IGS_CA_INST_ALL CI1
, IGF_AP_FA_BASE_REC_ALL AP
, IGS_CA_INST_ALL CI2
, IGF_AW_FUND_MAST_ALL AW
WHERE SP.FUND_ID = AW.FUND_ID
AND SP.PERSON_ID = PA.PARTY_ID
AND SP.BASE_ID = AP.BASE_ID
AND SP.LD_CAL_TYPE = CI1.CAL_TYPE
AND SP.LD_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND AP.CI_CAL_TYPE = CI2.CAL_TYPE
AND AP.CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER WITH READ ONLY