Product: | IGF - Financial Aid |
---|---|
Description: | Sets up the re-package priority of funds at the Fund Level |
Implementation/DBA Data: | APPS.IGF_AW_FN_RPKG_PRTY_V |
SELECT RPP.ROWID
, RPP.FUND_ORDER_NUM
, RPP.CI_CAL_TYPE
, RPP.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, RPP.FUND_ID
, FM.FUND_CODE
, FM.DESCRIPTION
, FNDS1.MEANING SYS_FUND_TYPE_DESC
, FNDS2.MEANING FUND_SOURCE_DESC
, FNDS3.MEANING SYS_FUND_CODE_DESC
, RPP.CREATED_BY
, RPP.CREATION_DATE
, RPP.LAST_UPDATED_BY
, RPP.LAST_UPDATE_DATE
, RPP.LAST_UPDATE_LOGIN
FROM IGF_AW_FN_RPKG_PRTY RPP
, IGF_AW_FUND_MAST_V FM
, IGF_LOOKUPS_VIEW FNDS1
, IGF_LOOKUPS_VIEW FNDS2
, IGF_LOOKUPS_VIEW FNDS3
, IGS_CA_INST CA
WHERE FM.FUND_ID = RPP.FUND_ID
AND FNDS1.LOOKUP_TYPE = 'IGF_AW_SYS_FUND_TYPE'
AND FM.SYS_FUND_TYPE = FNDS1.LOOKUP_CODE
AND FNDS2.LOOKUP_TYPE = 'IGF_AW_FUND_SOURCE'
AND FM.FUND_SOURCE = FNDS2.LOOKUP_CODE
AND FNDS3.LOOKUP_TYPE = 'IGF_AW_FED_FUND'
AND FM.FED_FUND_CODE = FNDS3.LOOKUP_CODE
AND CA.CAL_TYPE = RPP.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = RPP.CI_SEQUENCE_NUMBER