SELECT HP.PARTY_NAME, HP.PARTY_NUMBER, FC.DESCRIPTION, SPF.FUND_CODE, SPF.PERSON_ID, SPF.COURSE_CD, SPF.SPO_SEQUENCE_NUMBER, SPF.CREATED_BY, SPF.CREATION_DATE, SPF.LAST_UPDATED_BY, SPF.LAST_UPDATE_DATE FROM IGS_PR_STDNT_PR_FND SPF, HZ_PARTIES HP, IGF_AW_FUND_CAT_ALL FC WHERE SPF.PERSON_ID = HP.PARTY_ID AND SPF.FUND_CODE = FC.FUND_CODE WITH READ ONLY
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, FC.DESCRIPTION
, SPF.FUND_CODE
, SPF.PERSON_ID
, SPF.COURSE_CD
, SPF.SPO_SEQUENCE_NUMBER
, SPF.CREATED_BY
, SPF.CREATION_DATE
, SPF.LAST_UPDATED_BY
, SPF.LAST_UPDATE_DATE
FROM IGS_PR_STDNT_PR_FND SPF
, HZ_PARTIES HP
, IGF_AW_FUND_CAT_ALL FC
WHERE SPF.PERSON_ID = HP.PARTY_ID
AND SPF.FUND_CODE = FC.FUND_CODE WITH READ ONLY
|
|
|