Product: | IGF - Financial Aid (Obsolete) |
---|---|
Description: | Retrieves the Promissory Note Status History details |
Implementation/DBA Data: | Not implemented in this database |
SELECT DLPNH.ROWID
, DLPNH.DLPNH_ID
, DLPNH.LOAN_ID
, DLPNH.PNOTE_STATUS
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PNOTE_STATUS'
, DLPNH.PNOTE_STATUS)
, DLPNH.PNOTE_STATUS_DATE
, DLPNH.CREATED_BY
, DLPNH.CREATION_DATE
, DLPNH.LAST_UPDATED_BY
, DLPNH.LAST_UPDATE_DATE
, DLPNH.LAST_UPDATE_LOGIN
, DLPNH.REQUEST_ID
, DLPNH.PROGRAM_APPLICATION_ID
, DLPNH.PROGRAM_ID
, DLPNH.PROGRAM_UPDATE_DATE
, LOAN.LOAN_NUMBER
FROM IGF_SL_PNOTE_STAT_H DLPNH
, IGF_SL_LOANS LOAN
WHERE LOAN.LOAN_ID = DLPNH.LOAN_ID