Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds Direct Loan Promissory Note Activities |
Implementation/DBA Data: | APPS.IGFFV_DL_PNOTE_STATUS_HISTORY |
SELECT '_LA:HIST.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_STATUS:MEANING'
, HIST.PNOTE_STATUS_DATE
, PER.PARTY_NUMBER
, PER.PERSON_FIRST_NAME
, PER.PERSON_LAST_NAME
, PER.PERSON_MIDDLE_NAME
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, AWDY.ALTERNATE_CODE
, LOANS.LOAN_NUMBER
, LOANS.LOAN_PER_BEGIN_DATE
, LOANS.LOAN_PER_END_DATE
, '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING'
, HIST.LOAN_ID
, LOR.P_PERSON_ID
, HIST.DLPNH_ID
, HIST.CREATED_BY
, HIST.CREATION_DATE
, HIST.LAST_UPDATED_BY
, HIST.LAST_UPDATE_DATE
FROM IGF_SL_PNOTE_STAT_H HIST
, IGF_SL_LOR_ALL LOR
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWARDS
, IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL AWDY
, HZ_PARTIES PER
WHERE HIST.LOAN_ID = LOR.LOAN_ID
AND LOR.LOAN_ID = LOANS.LOAN_ID
AND LOANS.AWARD_ID = AWARDS.AWARD_ID
AND AWARDS.FUND_ID = FMAST.FUND_ID
AND FMAST.CI_CAL_TYPE = AWDY.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = AWDY.SEQUENCE_NUMBER
AND LOR.P_PERSON_ID = PER.PARTY_ID (+) WITH READ ONLY