SELECT STDP.ROWID, STDP.FEE_CLS_PRG_ID, STDP.FEE_CLS_ID, STDP.COURSE_CD, STDP.VERSION_NUMBER, STDP.FEE_PERCENT, STDP.MAX_AMOUNT, STDP.CREATED_BY, STDP.CREATION_DATE, STDP.LAST_UPDATED_BY, STDP.LAST_UPDATE_DATE, STDP.LAST_UPDATE_LOGIN, STDP.ORG_ID FROM IGF_SP_STD_PRG STDP, IGF_SP_STD_FC STDFC, IGS_PS_VER CRV WHERE STDP.FEE_CLS_ID = STDFC.FEE_CLS_ID AND STDP.COURSE_CD = CRV.COURSE_CD AND STDP.VERSION_NUMBER = CRV.VERSION_NUMBER
SELECT STDP.ROWID
, STDP.FEE_CLS_PRG_ID
, STDP.FEE_CLS_ID
, STDP.COURSE_CD
, STDP.VERSION_NUMBER
, STDP.FEE_PERCENT
, STDP.MAX_AMOUNT
, STDP.CREATED_BY
, STDP.CREATION_DATE
, STDP.LAST_UPDATED_BY
, STDP.LAST_UPDATE_DATE
, STDP.LAST_UPDATE_LOGIN
, STDP.ORG_ID
FROM IGF_SP_STD_PRG STDP
, IGF_SP_STD_FC STDFC
, IGS_PS_VER CRV
WHERE STDP.FEE_CLS_ID = STDFC.FEE_CLS_ID
AND STDP.COURSE_CD = CRV.COURSE_CD
AND STDP.VERSION_NUMBER = CRV.VERSION_NUMBER
|
|
|