View: IGF_SL_PRK_LOAN_V

Product:	IGF - Financial Aid
Description:	Stores Perkins Loan information for student in financial aid
Implementation/DBA Data:	APPS.IGF_SL_PRK_LOAN_V

View Text

SELECT LAR.LOAN_NUMBER LOAN_NUMBER
, P_STUD.API_PERSON_ID S_SSN
, P_STUD.SURNAME S_LAST_NAME
, P_STUD.GIVEN_NAMES S_FIRST_NAME
, P_STUD.MIDDLE_NAME S_MIDDLE_NAME
, P_STUD.FULL_NAME S_FULL_NAME
, P_STUD.BIRTH_DT S_DATE_OF_BIRTH
, S_PERMT.ADDR_LINE_1 S_PERMT_ADDR1
, S_PERMT.ADDR_LINE_2 S_PERMT_ADDR2
, S_PERMT.ADDR_LINE_3 S_PERMT_ADDR3
, S_PERMT.ADDR_LINE_4 S_PERMT_ADDR4
, S_PERMT.CITY S_PERMT_CITY
, S_PERMT.STATE S_PERMT_STATE
, S_PERMT.PROVINCE S_PERMT_PROVINCE
, S_PERMT.COUNTY S_PERMT_COUNTY
, S_PERMT.COUNTRY S_PERMT_COUNTRY
, S_PERMT.POSTAL_CODE S_PERMT_ZIP
, P_STUD.EMAIL_ADDR S_EMAIL_ADDR
, AWD.ACCEPTED_AMT LOAN_AMT_ACCEPTED
, LAR.LOAN_PER_BEGIN_DATE LOAN_PER_BEGIN_DATE
, LAR.LOAN_PER_END_DATE LOAN_PER_END_DATE
, ISIR.DRIVER_LICENSE_NUMBER S_LICENSE_NUM
, ISIR.DRIVER_LICENSE_STATE S_LICENSE_STATE
, IGF_SL_GEN.GET_PERSON_PHONE(FABASE.PERSON_ID)
FROM IGF_SL_LOANS LAR
, IGF_AW_AWARD AWD
, IGF_AW_FUND_MAST FMAST
, IGF_AW_FUND_CAT FCAT
, IGF_AP_FA_BASE_REC FABASE
, IGF_AP_PERSON_V P_STUD
, IGF_AP_ISIR_MATCHED ISIR
, IGF_SL_ADDR_V S_PERMT
WHERE LAR.AWARD_ID = AWD.AWARD_ID
AND AWD.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND AWD.BASE_ID = FABASE.BASE_ID
AND NVL(FABASE.PAYMENT_ISIR_ID
, 0) = ISIR.ISIR_ID(+)
AND FABASE.PERSON_ID = P_STUD.PERSON_ID
AND FABASE.PERSON_ID = S_PERMT.PERSON_ID(+)
AND S_PERMT.SITE_USE_TYPE(+) = 'HOME'
AND FCAT.FED_FUND_CODE = 'PRK'

Columns