Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds Preferred FFELP Lenders |
Implementation/DBA Data: | APPS.IGFFV_FFELP_PREFERRED_LENDERS |
SELECT CLPRL.RELATIONSHIP_CD
, CLPRL.START_DATE
, CLPRL.END_DATE
, RECP.RELATIONSHIP_CD_DESC
, RECP.RECIPIENT_TYPE
, HZ.PARTY_NUMBER
, HZ.PERSON_FIRST_NAME
, HZ.PERSON_LAST_NAME
, HZ.PERSON_MIDDLE_NAME
, CLPRL.PERSON_ID
, RECP.LENDER_ID
, RECP.LEND_NON_ED_BRC_ID
, RECP.GUARANTOR_ID
, RECP.RECIPIENT_ID
, RECP.RECIP_NON_ED_BRC_ID
, CLPRL.CLPRL_ID
, CLPRL.CREATED_BY
, CLPRL.CREATION_DATE
, CLPRL.LAST_UPDATED_BY
, CLPRL.LAST_UPDATE_DATE
FROM IGF_SL_CL_PREF_LENDERS CLPRL
, IGF_SL_CL_RECIPIENT RECP
, HZ_PARTIES HZ
WHERE RECP.RELATIONSHIP_CD = CLPRL.RELATIONSHIP_CD
AND HZ.PARTY_ID = CLPRL.PERSON_ID WITH READ ONLY