Product: | IGF - Financial Aid |
---|---|
Description: | Sets up the re-package priority of funds at the System Fund Level |
Implementation/DBA Data: | APPS.IGF_AW_REPKG_PRTY_V |
SELECT RPP.ROWID
, RPP.FUND_ORDER_NUM
, RPP.SYS_FUND_TYPE_CODE
, FNDS1.MEANING SYS_FUND_TYPE_DESC
, RPP.FUND_SOURCE_CODE
, FNDS2.MEANING FUND_SOURCE_DESC
, RPP.SYS_FUND_CODE
, 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_REPKG_PRTY RPP
, IGF_LOOKUPS_VIEW FNDS1
, IGF_LOOKUPS_VIEW FNDS2
, IGF_LOOKUPS_VIEW FNDS3
WHERE FNDS1.LOOKUP_TYPE = 'IGF_AW_SYS_FUND_TYPE'
AND RPP.SYS_FUND_TYPE_CODE = FNDS1.LOOKUP_CODE
AND FNDS2.LOOKUP_TYPE = 'IGF_AW_FUND_SOURCE'
AND RPP.FUND_SOURCE_CODE = FNDS2.LOOKUP_CODE
AND FNDS3.LOOKUP_TYPE = 'IGF_AW_FED_FUND'
AND RPP.SYS_FUND_CODE = FNDS3.LOOKUP_CODE