Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_LOANS_V |
SELECT LAR.ROWID
, LAR.LOAN_ID
, LAR.SEQ_NUM
, AWDV.BASE_ID
, AWDV.AWARD_ID
, BASE.PERSON_ID
, P.PARTY_NUMBER
, P.PARTY_NAME
, PIT.API_PERSON_ID
, AWDV.FUND_ID
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, FMAST.FUND_CODE
, FMAST.FUND_CODE||TO_CHAR(LAR.SEQ_NUM)
, FCAT.FUND_SOURCE
, FCAT.FUND_TYPE
, FCAT.SYS_FUND_TYPE
, FCAT.FED_FUND_CODE
, AWDV.OFFERED_AMT
, AWDV.ACCEPTED_AMT
, LAR.LOAN_NUMBER
, LAR.LOAN_PER_BEGIN_DATE
, LAR.LOAN_PER_END_DATE
, LAR.LOAN_STATUS
, LAR.LOAN_STATUS_DATE
, LAR.LOAN_CHG_STATUS
, LAR.LOAN_CHG_STATUS_DATE
, LAR.ACTIVE
, LAR.ACTIVE_DATE
, LAR.BORW_DETRM_CODE
, LAR.CREATED_BY
, LAR.CREATION_DATE
, LAR.LAST_UPDATED_BY
, LAR.LAST_UPDATE_DATE
, LAR.LAST_UPDATE_LOGIN
, LAR.REQUEST_ID
, LAR.PROGRAM_APPLICATION_ID
, LAR.PROGRAM_ID
, LAR.PROGRAM_UPDATE_DATE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_LOAN_STATUS'
, LAR.LOAN_STATUS)
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_LOAN_CHG_STATUS'
, LAR.LOAN_CHG_STATUS)
, LAR.LEGACY_RECORD_FLAG
, LAR.EXTERNAL_LOAN_ID_TXT
FROM IGF_SL_LOANS LAR
, IGF_AW_AWARD AWDV
, IGF_AW_FUND_MAST FMAST
, IGF_AW_FUND_CAT FCAT
, IGS_CA_INST CI
, IGF_AP_FA_BASE_REC BASE
, HZ_PARTIES P
, (SELECT API_PERSON_ID
, PE_PERSON_ID
FROM IGS_PE_PERSON_ID_TYP PIT_2
, IGS_PE_ALT_PERS_ID API_2
WHERE API_2.PERSON_ID_TYPE = PIT_2.PERSON_ID_TYPE
AND PIT_2.S_PERSON_ID_TYPE = 'SSN'
AND SYSDATE BETWEEN API_2.START_DT
AND NVL(API_2.END_DT
, SYSDATE)) PIT
WHERE LAR.AWARD_ID = AWDV.AWARD_ID
AND FMAST.FUND_ID = AWDV.FUND_ID
AND BASE.BASE_ID = AWDV.BASE_ID
AND CI.CAL_TYPE = BASE.CI_CAL_TYPE
AND CI.SEQUENCE_NUMBER = BASE.CI_SEQUENCE_NUMBER
AND FCAT.FUND_CODE = FMAST.FUND_CODE
AND BASE.PERSON_ID = P.PARTY_ID
AND BASE.PERSON_ID = PIT.PE_PERSON_ID (+)