Product: | IGF - Financial Aid |
---|---|
Description: | FFELP Preferred Lender Assignment View |
Implementation/DBA Data: | APPS.IGF_SL_CL_PREF_LENDERS_V |
SELECT CLPRL.ROWID
, CLPRL.CLPRL_ID
, CLPRL.PERSON_ID
, CLPRL.RELATIONSHIP_CD
, RECP.RELATIONSHIP_CD_DESC
, CLPRL.START_DATE
, CLPRL.END_DATE
, CLPRL.OBJECT_VERSION_NUMBER
, CLPRL.CREATED_BY
, CLPRL.CREATION_DATE
, CLPRL.LAST_UPDATED_BY
, CLPRL.LAST_UPDATE_DATE
, CLPRL.LAST_UPDATE_LOGIN
, CLPRL.PROGRAM_APPLICATION_ID
, CLPRL.PROGRAM_ID
, CLPRL.PROGRAM_UPDATE_DATE
, CLPRL.REQUEST_ID
FROM IGF_SL_CL_PREF_LENDERS CLPRL
, IGF_SL_CL_RECIPIENT RECP
WHERE RECP.RELATIONSHIP_CD = CLPRL.RELATIONSHIP_CD