VIEW: APPS.IGF_SL_LOR_DTLS_V

Source

View Text - Preformatted

SELECT LAR.ROW_ID LAR_ROWID, LAR.LOAN_ID LOAN_ID, AWDV.BASE_ID BASE_ID, AWDV.AWARD_ID AWARD_ID, AWDV.STUDENT_ID STUDENT_ID, AWDV.FUND_ID FUND_ID, LAR.SEQ_NUM SEQ_NUM, LOR.ROW_ID LOR_ROWID, LOR.ORIGINATION_ID ORIGINATION_ID, LAR.LOAN_NUMBER LOAN_NUMBER, AWDV.CI_CAL_TYPE CI_CAL_TYPE, AWDV.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER, AWDV.CI_START_DT CI_START_DT, AWDV.CI_END_DT CI_END_DT, AWDV.CI_ALTERNATE_CODE CI_ALTERNATE_CODE, AWDV.FUND_CODE LOAN_TYPE, AWDV.FUND_CODE||to_char(LAR.SEQ_NUM) LOAN_TYPE_NUM, AWDV.FUND_SOURCE FUND_SOURCE, AWDV.FUND_TYPE FUND_TYPE, AWDV.SYS_FUND_TYPE SYS_FUND_TYPE, AWDV.FED_FUND_CODE FED_FUND_CODE, AWDV.OFFERED_AMT LOAN_AMT_OFFERED, AWDV.ACCEPTED_AMT LOAN_AMT_ACCEPTED, LAR.LOAN_PER_BEGIN_DATE LOAN_PER_BEGIN_DATE, LAR.LOAN_PER_END_DATE LOAN_PER_END_DATE, LAR.LOAN_STATUS LOAN_STATUS, LAR.LOAN_STATUS_DATE LOAN_STATUS_DATE, LAR.LOAN_CHG_STATUS LOAN_CHG_STATUS, LAR.LOAN_CHG_STATUS_DATE LOAN_CHG_STATUS_DATE, LAR.ACTIVE ACTIVE, LAR.ACTIVE_DATE ACTIVE_DATE, lar.borw_detrm_code borw_detrm_code, lkv.meaning borw_detrm, LOR.SCH_CERT_DATE SCH_CERT_DATE, LOR.ORIG_STATUS_FLAG ORIG_STATUS_FLAG, LOR.ORIG_BATCH_ID ORIG_BATCH_ID, LOR.ORIG_BATCH_DATE ORIG_BATCH_DATE, LOR.CHG_BATCH_ID CHG_BATCH_ID, LOR.ORIG_ACK_DATE ORIG_ACK_DATE, LOR.CREDIT_OVERRIDE CREDIT_OVERRIDE, LOR.CREDIT_DECISION_DATE CREDIT_DECISION_DATE, LOR.REQ_SERIAL_LOAN_CODE REQ_SERIAL_LOAN_CODE, LOR.ACT_SERIAL_LOAN_CODE ACT_SERIAL_LOAN_CODE, LOR.PNOTE_DELIVERY_CODE PNOTE_DELIVERY_CODE, LOR.PNOTE_STATUS PNOTE_STATUS, LOR.PNOTE_STATUS_DATE PNOTE_STATUS_DATE, LOR.PNOTE_ID PNOTE_ID, LOR.PNOTE_PRINT_IND PNOTE_PRINT_IND, LOR.PNOTE_ACCEPT_AMT PNOTE_ACCEPT_AMT, LOR.PNOTE_ACCEPT_DATE PNOTE_ACCEPT_DATE, LOR.PNOTE_BATCH_ID PNOTE_BATCH_ID, LOR.PNOTE_ACK_DATE PNOTE_ACK_DATE, LOR.PNOTE_MPN_IND PNOTE_MPN_IND, LOR.UNSUB_ELIG_FOR_HEAL UNSUB_ELIG_FOR_HEAL, LOR.DISCLOSURE_PRINT_IND DISCLOSURE_PRINT_IND, LOR.ORIG_FEE_PERCT ORIG_FEE_PERCT, LOR.BORW_CONFIRM_IND BORW_CONFIRM_IND, LOR.BORW_INTEREST_IND BORW_INTEREST_IND, LOR.BORW_OUTSTD_LOAN_CODE BORW_OUTSTD_LOAN_CODE, LOR.UNSUB_ELIG_FOR_DEPNT UNSUB_ELIG_FOR_DEPNT, LOR.GUARANTEE_AMT GUARANTEE_AMT, LOR.GUARANTEE_DATE GUARANTEE_DATE, LOR.GUARNT_AMT_REDN_CODE GUARNT_AMT_REDN_CODE, LOR.GUARNT_STATUS_CODE GUARNT_STATUS_CODE, LOR.GUARNT_STATUS_DATE GUARNT_STATUS_DATE, LOR.LEND_APPRV_DENIED_CODE LEND_APPRV_DENIED_CODE, LOR.LEND_APPRV_DENIED_DATE LEND_APPRV_DENIED_DATE, LOR.LEND_STATUS_CODE LEND_STATUS_CODE, LOR.LEND_STATUS_DATE LEND_STATUS_DATE, LOR.GUARNT_ADJ_IND GUARNT_ADJ_IND, LOR.GRADE_LEVEL_CODE GRADE_LEVEL_CODE, LOR.ENROLLMENT_CODE ENROLLMENT_CODE, LOR.ANTICIP_COMPL_DATE ANTICIP_COMPL_DATE, LOR.BORW_LENDER_ID BORW_LENDER_ID, LOR.DUNS_BORW_LENDER_ID DUNS_BORW_LENDER_ID, LOR.GUARANTOR_ID GUARANTOR_ID, LOR.DUNS_GUARNT_ID DUNS_GUARNT_ID, LOR.PRC_TYPE_CODE PRC_TYPE_CODE, LOR.CL_SEQ_NUMBER CL_SEQ_NUMBER, LOR.LAST_RESORT_LENDER LAST_RESORT_LENDER, LOR.LENDER_ID LENDER_ID, LOR.DUNS_LENDER_ID DUNS_LENDER_ID, LOR.LEND_NON_ED_BRC_ID LEND_NON_ED_BRC_ID, LOR.RECIPIENT_ID RECIPIENT_ID, LOR.RECIPIENT_TYPE RECIPIENT_TYPE, LOR.DUNS_RECIP_ID DUNS_RECIP_ID, LOR.RECIP_NON_ED_BRC_ID RECIP_NON_ED_BRC_ID, LOR.REC_TYPE_IND REC_TYPE_IND, LOR.CL_LOAN_TYPE CL_LOAN_TYPE, LOR.CL_REC_STATUS CL_REC_STATUS, LOR.CL_REC_STATUS_LAST_UPDATE CL_REC_STATUS_LAST_UPDATE, LOR.ALT_PROG_TYPE_CODE ALT_PROG_TYPE_CODE, LOR.ALT_APPL_VER_CODE ALT_APPL_VER_CODE, LOR.MPN_CONFIRM_CODE MPN_CONFIRM_CODE, LOR.RESP_TO_ORIG_CODE RESP_TO_ORIG_CODE, LOR.APPL_LOAN_PHASE_CODE APPL_LOAN_PHASE_CODE, LOR.APPL_LOAN_PHASE_CODE_CHG APPL_LOAN_PHASE_CODE_CHG, LOR.APPL_SEND_ERROR_CODES APPL_SEND_ERROR_CODES, LOR.TOT_OUTSTD_STAFFORD TOT_OUTSTD_STAFFORD, LOR.TOT_OUTSTD_PLUS TOT_OUTSTD_PLUS, LOR.ALT_BORW_TOT_DEBT ALT_BORW_TOT_DEBT, LOR.ACT_INTEREST_RATE ACT_INTEREST_RATE, LOR.SERVICE_TYPE_CODE SERVICE_TYPE_CODE, LOR.REV_NOTICE_OF_GUARNT REV_NOTICE_OF_GUARNT, LOR.SCH_REFUND_AMT SCH_REFUND_AMT, LOR.SCH_REFUND_DATE SCH_REFUND_DATE, LOR.UNIQ_LAYOUT_VEND_CODE UNIQ_LAYOUT_VEND_CODE, LOR.UNIQ_LAYOUT_IDENT_CODE UNIQ_LAYOUT_IDENT_CODE, LOR.P_PERSON_ID P_PERSON_ID, P_PARENT.API_PERSON_ID P_SSN, LOR.P_SSN_CHG_DATE P_SSN_CHG_DATE, P_PARENT.SURNAME P_LAST_NAME, P_PARENT.GIVEN_NAMES P_FIRST_NAME, P_PARENT.MIDDLE_NAME P_MIDDLE_NAME, P_PARENT.FULL_NAME P_FULL_NAME, P_PERMT.ADDR_LINE_1 P_PERMT_ADDR1, P_PERMT.ADDR_LINE_2 P_PERMT_ADDR2, P_PERMT.CITY P_PERMT_CITY, P_PERMT.STATE P_PERMT_STATE, P_PERMT.POSTAL_CODE P_PERMT_ZIP, LOR.P_PERMT_ADDR_CHG_DATE P_PERMT_ADDR_CHG_DATE, P_PARENT.EMAIL_ADDR P_EMAIL_ADDR, P_PARENT.BIRTH_DT P_DATE_OF_BIRTH, LOR.P_DOB_CHG_DATE P_DOB_CHG_DATE, LOR.P_DEFAULT_STATUS P_DEFAULT_STATUS, PLBW.LICENSE_NUM P_LICENSE_NUM, PLBW.LICENSE_STATE P_LICENSE_STATE, PLBW.CITIZENSHIP_STATUS P_CITIZENSHIP_STATUS, PLBW.ALIEN_REG_NUM P_ALIEN_REG_NUM, PLBW.STATE_OF_LEGAL_RES P_STATE_OF_LEGAL_RES, PLBW.LEGAL_RES_DATE P_LEGAL_RES_DATE, LOR.P_SIGNATURE_CODE P_SIGNATURE_CODE, LOR.P_SIGNATURE_DATE P_SIGNATURE_DATE, P_STUD.API_PERSON_ID S_SSN, LOR.S_SSN_CHG_DATE S_SSN_CHG_DATE, 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, S_PERMT.ADDR_LINE_1 S_PERMT_ADDR1, S_PERMT.ADDR_LINE_2 S_PERMT_ADDR2, S_PERMT.CITY S_PERMT_CITY, S_PERMT.STATE S_PERMT_STATE, S_PERMT.POSTAL_CODE S_PERMT_ZIP, LOR.S_PERMT_ADDR_CHG_DATE S_PERMT_ADDR_CHG_DATE, S_LOCAL.ADDR_LINE_1 S_LOCAL_ADDR1, S_LOCAL.ADDR_LINE_2 S_LOCAL_ADDR2, S_LOCAL.CITY S_LOCAL_CITY, S_LOCAL.STATE S_LOCAL_STATE, S_LOCAL.POSTAL_CODE S_LOCAL_ZIP, LOR.S_LOCAL_ADDR_CHG_DATE S_LOCAL_ADDR_CHG_DATE, P_STUD.EMAIL_ADDR S_EMAIL_ADDR, P_STUD.BIRTH_DT S_DATE_OF_BIRTH, LOR.S_DOB_CHG_DATE S_DOB_CHG_DATE, LOR.S_DEFAULT_STATUS S_DEFAULT_STATUS, LOR.S_SIGNATURE_CODE S_SIGNATURE_CODE, LOR.CREATED_BY CREATED_BY, LOR.CREATION_DATE CREATION_DATE, LOR.LAST_UPDATED_BY LAST_UPDATED_BY, LOR.LAST_UPDATE_DATE LAST_UPDATE_DATE, LOR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LOR.REQUEST_ID REQUEST_ID, LOR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, LOR.PROGRAM_ID PROGRAM_ID, LOR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, AWDV.paid_amt, lor.elec_mpn_ind, lor.borr_sign_ind, lor.stud_sign_ind, lor.borr_credit_auth_code FROM IGF_SL_LOANS LAR, IGF_SL_LOR LOR, IGF_AP_PERSON_V P_STUD, IGF_AP_PERSON_V P_PARENT, IGF_SL_PLUS_BORW PLBW, IGF_SL_ADDR_V P_PERMT, IGF_SL_ADDR_V S_PERMT, IGF_SL_ADDR_V S_LOCAL, IGF_AW_AWARD_V AWDV, igs_lookups_view lkv WHERE LAR.LOAN_ID = LOR.LOAN_ID AND LAR.AWARD_ID = AWDV.AWARD_ID AND AWDV.STUDENT_ID = P_STUD.PERSON_ID AND NVL(LOR.P_PERSON_ID,0) = P_PARENT.PERSON_ID(+) AND NVL(LOR.P_PERSON_ID,0) = PLBW.PERSON_ID(+) AND NVL(LOR.P_PERSON_ID,0) = P_PERMT.PERSON_ID(+) AND P_PERMT.SITE_USE_TYPE(+) = 'HOME' AND AWDV.STUDENT_ID = S_PERMT.PERSON_ID(+) AND S_PERMT.SITE_USE_TYPE(+) = 'HOME' AND AWDV.STUDENT_ID = S_LOCAL.PERSON_ID(+) AND S_LOCAL.SITE_USE_TYPE(+) = 'RESIDES_AT' and lar.borw_detrm_code=lkv.lookup_code(+) and lkv.lookup_type(+)= 'IGS_FI_BORW_DETRM'

View Text - HTML Formatted

SELECT LAR.ROW_ID LAR_ROWID
, LAR.LOAN_ID LOAN_ID
, AWDV.BASE_ID BASE_ID
, AWDV.AWARD_ID AWARD_ID
, AWDV.STUDENT_ID STUDENT_ID
, AWDV.FUND_ID FUND_ID
, LAR.SEQ_NUM SEQ_NUM
, LOR.ROW_ID LOR_ROWID
, LOR.ORIGINATION_ID ORIGINATION_ID
, LAR.LOAN_NUMBER LOAN_NUMBER
, AWDV.CI_CAL_TYPE CI_CAL_TYPE
, AWDV.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, AWDV.CI_START_DT CI_START_DT
, AWDV.CI_END_DT CI_END_DT
, AWDV.CI_ALTERNATE_CODE CI_ALTERNATE_CODE
, AWDV.FUND_CODE LOAN_TYPE
, AWDV.FUND_CODE||TO_CHAR(LAR.SEQ_NUM) LOAN_TYPE_NUM
, AWDV.FUND_SOURCE FUND_SOURCE
, AWDV.FUND_TYPE FUND_TYPE
, AWDV.SYS_FUND_TYPE SYS_FUND_TYPE
, AWDV.FED_FUND_CODE FED_FUND_CODE
, AWDV.OFFERED_AMT LOAN_AMT_OFFERED
, AWDV.ACCEPTED_AMT LOAN_AMT_ACCEPTED
, LAR.LOAN_PER_BEGIN_DATE LOAN_PER_BEGIN_DATE
, LAR.LOAN_PER_END_DATE LOAN_PER_END_DATE
, LAR.LOAN_STATUS LOAN_STATUS
, LAR.LOAN_STATUS_DATE LOAN_STATUS_DATE
, LAR.LOAN_CHG_STATUS LOAN_CHG_STATUS
, LAR.LOAN_CHG_STATUS_DATE LOAN_CHG_STATUS_DATE
, LAR.ACTIVE ACTIVE
, LAR.ACTIVE_DATE ACTIVE_DATE
, LAR.BORW_DETRM_CODE BORW_DETRM_CODE
, LKV.MEANING BORW_DETRM
, LOR.SCH_CERT_DATE SCH_CERT_DATE
, LOR.ORIG_STATUS_FLAG ORIG_STATUS_FLAG
, LOR.ORIG_BATCH_ID ORIG_BATCH_ID
, LOR.ORIG_BATCH_DATE ORIG_BATCH_DATE
, LOR.CHG_BATCH_ID CHG_BATCH_ID
, LOR.ORIG_ACK_DATE ORIG_ACK_DATE
, LOR.CREDIT_OVERRIDE CREDIT_OVERRIDE
, LOR.CREDIT_DECISION_DATE CREDIT_DECISION_DATE
, LOR.REQ_SERIAL_LOAN_CODE REQ_SERIAL_LOAN_CODE
, LOR.ACT_SERIAL_LOAN_CODE ACT_SERIAL_LOAN_CODE
, LOR.PNOTE_DELIVERY_CODE PNOTE_DELIVERY_CODE
, LOR.PNOTE_STATUS PNOTE_STATUS
, LOR.PNOTE_STATUS_DATE PNOTE_STATUS_DATE
, LOR.PNOTE_ID PNOTE_ID
, LOR.PNOTE_PRINT_IND PNOTE_PRINT_IND
, LOR.PNOTE_ACCEPT_AMT PNOTE_ACCEPT_AMT
, LOR.PNOTE_ACCEPT_DATE PNOTE_ACCEPT_DATE
, LOR.PNOTE_BATCH_ID PNOTE_BATCH_ID
, LOR.PNOTE_ACK_DATE PNOTE_ACK_DATE
, LOR.PNOTE_MPN_IND PNOTE_MPN_IND
, LOR.UNSUB_ELIG_FOR_HEAL UNSUB_ELIG_FOR_HEAL
, LOR.DISCLOSURE_PRINT_IND DISCLOSURE_PRINT_IND
, LOR.ORIG_FEE_PERCT ORIG_FEE_PERCT
, LOR.BORW_CONFIRM_IND BORW_CONFIRM_IND
, LOR.BORW_INTEREST_IND BORW_INTEREST_IND
, LOR.BORW_OUTSTD_LOAN_CODE BORW_OUTSTD_LOAN_CODE
, LOR.UNSUB_ELIG_FOR_DEPNT UNSUB_ELIG_FOR_DEPNT
, LOR.GUARANTEE_AMT GUARANTEE_AMT
, LOR.GUARANTEE_DATE GUARANTEE_DATE
, LOR.GUARNT_AMT_REDN_CODE GUARNT_AMT_REDN_CODE
, LOR.GUARNT_STATUS_CODE GUARNT_STATUS_CODE
, LOR.GUARNT_STATUS_DATE GUARNT_STATUS_DATE
, LOR.LEND_APPRV_DENIED_CODE LEND_APPRV_DENIED_CODE
, LOR.LEND_APPRV_DENIED_DATE LEND_APPRV_DENIED_DATE
, LOR.LEND_STATUS_CODE LEND_STATUS_CODE
, LOR.LEND_STATUS_DATE LEND_STATUS_DATE
, LOR.GUARNT_ADJ_IND GUARNT_ADJ_IND
, LOR.GRADE_LEVEL_CODE GRADE_LEVEL_CODE
, LOR.ENROLLMENT_CODE ENROLLMENT_CODE
, LOR.ANTICIP_COMPL_DATE ANTICIP_COMPL_DATE
, LOR.BORW_LENDER_ID BORW_LENDER_ID
, LOR.DUNS_BORW_LENDER_ID DUNS_BORW_LENDER_ID
, LOR.GUARANTOR_ID GUARANTOR_ID
, LOR.DUNS_GUARNT_ID DUNS_GUARNT_ID
, LOR.PRC_TYPE_CODE PRC_TYPE_CODE
, LOR.CL_SEQ_NUMBER CL_SEQ_NUMBER
, LOR.LAST_RESORT_LENDER LAST_RESORT_LENDER
, LOR.LENDER_ID LENDER_ID
, LOR.DUNS_LENDER_ID DUNS_LENDER_ID
, LOR.LEND_NON_ED_BRC_ID LEND_NON_ED_BRC_ID
, LOR.RECIPIENT_ID RECIPIENT_ID
, LOR.RECIPIENT_TYPE RECIPIENT_TYPE
, LOR.DUNS_RECIP_ID DUNS_RECIP_ID
, LOR.RECIP_NON_ED_BRC_ID RECIP_NON_ED_BRC_ID
, LOR.REC_TYPE_IND REC_TYPE_IND
, LOR.CL_LOAN_TYPE CL_LOAN_TYPE
, LOR.CL_REC_STATUS CL_REC_STATUS
, LOR.CL_REC_STATUS_LAST_UPDATE CL_REC_STATUS_LAST_UPDATE
, LOR.ALT_PROG_TYPE_CODE ALT_PROG_TYPE_CODE
, LOR.ALT_APPL_VER_CODE ALT_APPL_VER_CODE
, LOR.MPN_CONFIRM_CODE MPN_CONFIRM_CODE
, LOR.RESP_TO_ORIG_CODE RESP_TO_ORIG_CODE
, LOR.APPL_LOAN_PHASE_CODE APPL_LOAN_PHASE_CODE
, LOR.APPL_LOAN_PHASE_CODE_CHG APPL_LOAN_PHASE_CODE_CHG
, LOR.APPL_SEND_ERROR_CODES APPL_SEND_ERROR_CODES
, LOR.TOT_OUTSTD_STAFFORD TOT_OUTSTD_STAFFORD
, LOR.TOT_OUTSTD_PLUS TOT_OUTSTD_PLUS
, LOR.ALT_BORW_TOT_DEBT ALT_BORW_TOT_DEBT
, LOR.ACT_INTEREST_RATE ACT_INTEREST_RATE
, LOR.SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, LOR.REV_NOTICE_OF_GUARNT REV_NOTICE_OF_GUARNT
, LOR.SCH_REFUND_AMT SCH_REFUND_AMT
, LOR.SCH_REFUND_DATE SCH_REFUND_DATE
, LOR.UNIQ_LAYOUT_VEND_CODE UNIQ_LAYOUT_VEND_CODE
, LOR.UNIQ_LAYOUT_IDENT_CODE UNIQ_LAYOUT_IDENT_CODE
, LOR.P_PERSON_ID P_PERSON_ID
, P_PARENT.API_PERSON_ID P_SSN
, LOR.P_SSN_CHG_DATE P_SSN_CHG_DATE
, P_PARENT.SURNAME P_LAST_NAME
, P_PARENT.GIVEN_NAMES P_FIRST_NAME
, P_PARENT.MIDDLE_NAME P_MIDDLE_NAME
, P_PARENT.FULL_NAME P_FULL_NAME
, P_PERMT.ADDR_LINE_1 P_PERMT_ADDR1
, P_PERMT.ADDR_LINE_2 P_PERMT_ADDR2
, P_PERMT.CITY P_PERMT_CITY
, P_PERMT.STATE P_PERMT_STATE
, P_PERMT.POSTAL_CODE P_PERMT_ZIP
, LOR.P_PERMT_ADDR_CHG_DATE P_PERMT_ADDR_CHG_DATE
, P_PARENT.EMAIL_ADDR P_EMAIL_ADDR
, P_PARENT.BIRTH_DT P_DATE_OF_BIRTH
, LOR.P_DOB_CHG_DATE P_DOB_CHG_DATE
, LOR.P_DEFAULT_STATUS P_DEFAULT_STATUS
, PLBW.LICENSE_NUM P_LICENSE_NUM
, PLBW.LICENSE_STATE P_LICENSE_STATE
, PLBW.CITIZENSHIP_STATUS P_CITIZENSHIP_STATUS
, PLBW.ALIEN_REG_NUM P_ALIEN_REG_NUM
, PLBW.STATE_OF_LEGAL_RES P_STATE_OF_LEGAL_RES
, PLBW.LEGAL_RES_DATE P_LEGAL_RES_DATE
, LOR.P_SIGNATURE_CODE P_SIGNATURE_CODE
, LOR.P_SIGNATURE_DATE P_SIGNATURE_DATE
, P_STUD.API_PERSON_ID S_SSN
, LOR.S_SSN_CHG_DATE S_SSN_CHG_DATE
, 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
, S_PERMT.ADDR_LINE_1 S_PERMT_ADDR1
, S_PERMT.ADDR_LINE_2 S_PERMT_ADDR2
, S_PERMT.CITY S_PERMT_CITY
, S_PERMT.STATE S_PERMT_STATE
, S_PERMT.POSTAL_CODE S_PERMT_ZIP
, LOR.S_PERMT_ADDR_CHG_DATE S_PERMT_ADDR_CHG_DATE
, S_LOCAL.ADDR_LINE_1 S_LOCAL_ADDR1
, S_LOCAL.ADDR_LINE_2 S_LOCAL_ADDR2
, S_LOCAL.CITY S_LOCAL_CITY
, S_LOCAL.STATE S_LOCAL_STATE
, S_LOCAL.POSTAL_CODE S_LOCAL_ZIP
, LOR.S_LOCAL_ADDR_CHG_DATE S_LOCAL_ADDR_CHG_DATE
, P_STUD.EMAIL_ADDR S_EMAIL_ADDR
, P_STUD.BIRTH_DT S_DATE_OF_BIRTH
, LOR.S_DOB_CHG_DATE S_DOB_CHG_DATE
, LOR.S_DEFAULT_STATUS S_DEFAULT_STATUS
, LOR.S_SIGNATURE_CODE S_SIGNATURE_CODE
, LOR.CREATED_BY CREATED_BY
, LOR.CREATION_DATE CREATION_DATE
, LOR.LAST_UPDATED_BY LAST_UPDATED_BY
, LOR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LOR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOR.REQUEST_ID REQUEST_ID
, LOR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, LOR.PROGRAM_ID PROGRAM_ID
, LOR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AWDV.PAID_AMT
, LOR.ELEC_MPN_IND
, LOR.BORR_SIGN_IND
, LOR.STUD_SIGN_IND
, LOR.BORR_CREDIT_AUTH_CODE
FROM IGF_SL_LOANS LAR
, IGF_SL_LOR LOR
, IGF_AP_PERSON_V P_STUD
, IGF_AP_PERSON_V P_PARENT
, IGF_SL_PLUS_BORW PLBW
, IGF_SL_ADDR_V P_PERMT
, IGF_SL_ADDR_V S_PERMT
, IGF_SL_ADDR_V S_LOCAL
, IGF_AW_AWARD_V AWDV
, IGS_LOOKUPS_VIEW LKV
WHERE LAR.LOAN_ID = LOR.LOAN_ID
AND LAR.AWARD_ID = AWDV.AWARD_ID
AND AWDV.STUDENT_ID = P_STUD.PERSON_ID
AND NVL(LOR.P_PERSON_ID
, 0) = P_PARENT.PERSON_ID(+)
AND NVL(LOR.P_PERSON_ID
, 0) = PLBW.PERSON_ID(+)
AND NVL(LOR.P_PERSON_ID
, 0) = P_PERMT.PERSON_ID(+)
AND P_PERMT.SITE_USE_TYPE(+) = 'HOME'
AND AWDV.STUDENT_ID = S_PERMT.PERSON_ID(+)
AND S_PERMT.SITE_USE_TYPE(+) = 'HOME'
AND AWDV.STUDENT_ID = S_LOCAL.PERSON_ID(+)
AND S_LOCAL.SITE_USE_TYPE(+) = 'RESIDES_AT'
AND LAR.BORW_DETRM_CODE=LKV.LOOKUP_CODE(+)
AND LKV.LOOKUP_TYPE(+)= 'IGS_FI_BORW_DETRM'