VIEW: APPS.IGF_SL_PRK_LOAN_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'