View: IGF_SL_CL_SETUP_OVRD_V

Product:	IGF - Financial Aid
Description:	FFELP Organization Unit Setup Override
Implementation/DBA Data:	APPS.IGF_SL_CL_SETUP_OVRD_V

View Text

SELECT CLSET.ROW_ID
, CLSET.CLSET_ID
, AWDYR.CI_CAL_TYPE
, AWDYR.CI_SEQUENCE_NUMBER
, CA.START_DT
, CA.END_DT
, CA.ALTERNATE_CODE
, CLSET.PARTY_ID
, ORGV.PARTY_NUMBER
, ORGV.PARTY_NAME
, CLSET.RELATIONSHIP_CD
, RECEP.RELATIONSHIP_CD_DESC
, CLSET.DEFAULT_FLAG
, RECEP.LENDER_ID
, RECEP.LEND_NON_ED_BRC_ID
, RECEP.GUARANTOR_ID
, RECEP.RECIPIENT_ID
, RECEP.RECIPIENT_TYPE
, RECEP.RECIP_NON_ED_BRC_ID
, CLSET.EST_ORIG_FEE_PERCT
, CLSET.EST_GUARNT_FEE_PERCT
, CLSET.EST_ALT_ORIG_FEE_PERCT
, CLSET.EST_ALT_GUARNT_FEE_PERCT
, CLSET.PRC_TYPE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PRC_TYPE_CODE'
, CLSET.PRC_TYPE_CODE)
, CLSET.REQ_SERIAL_LOAN_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_SERIAL_LOAN_CODE'
, CLSET.REQ_SERIAL_LOAN_CODE)
, CLSET.PNOTE_DELIVERY_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PNOTE_DELIVERY'
, CLSET.PNOTE_DELIVERY_CODE)
, CLSET.BORW_INTEREST_IND
, CLSET.HOLD_REL_IND
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_HOLD_REL_IND'
, CLSET.HOLD_REL_IND)
, CLSET.EFT_AUTHORIZATION
, CLSET.AUTO_LATE_DISB_IND
, CLSET.CREATED_BY
, CLSET.CREATION_DATE
, CLSET.LAST_UPDATED_BY
, CLSET.LAST_UPDATE_DATE
, CLSET.LAST_UPDATE_LOGIN
, CLSET.PLUS_PROCESSING_TYPE_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_PRC_TYPE_CODE'
, CLSET.PLUS_PROCESSING_TYPE_CODE)
, CLSET.FUND_RETURN_METHOD_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_CL_DB_FUND_DISB_METH'
, CLSET.FUND_RETURN_METHOD_CODE)
, CLSET.CL_VERSION
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_CL_VERSION'
, CLSET.CL_VERSION)
FROM IGS_CA_INST CA
, IGF_AP_BATCH_AW_MAP AWDYR
, IGF_SL_CL_SETUP CLSET
, IGF_SL_CL_RECIPIENT RECEP
, IGS_OR_INST_ORG_BASE_V ORGV
WHERE CA.CAL_TYPE = CLSET.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = CLSET.CI_SEQUENCE_NUMBER
AND AWDYR.CI_CAL_TYPE = CLSET.CI_CAL_TYPE
AND AWDYR.CI_SEQUENCE_NUMBER = CLSET.CI_SEQUENCE_NUMBER
AND ORGV.PARTY_ID = CLSET.PARTY_ID
AND RECEP.RELATIONSHIP_CD = CLSET.RELATIONSHIP_CD

Columns