VIEW: APPS.IGFFV_FUNDS

Source

View Text - Preformatted

SELECT FMAST.FUND_CODE, FMAST.DESCRIPTION, '_LA:FMAST.DISCONTINUE_FUND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.ENTITLEMENT:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.AUTO_PKG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.SELF_HELP:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , '_LA:FMAST.ALLOW_MAN_PKG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.UPDATE_NEED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.DISBURSE_FUND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.AVAILABLE_AMT, FMAST.OFFERED_AMT, FMAST.PENDING_AMT , FMAST.ACCEPTED_AMT , FMAST.DECLINED_AMT , FMAST.CANCELLED_AMT , FMAST.REMAINING_AMT , FMAST.ENROLLMENT_STATUS , '_LA:FMAST.PRN_AWARD_LETTER:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.OVER_AWARD_AMT , FMAST.OVER_AWARD_PERCT , FMAST.MIN_AWARD_AMT , FMAST.MAX_AWARD_AMT , FMAST.MAX_YEARLY_AMT , FMAST.MAX_LIFE_AMT , FMAST.MAX_LIFE_TERM , '_LA:FMAST.FM_FC_METHD:IGF_LOOKUPS_VIEW:IGF_AW_NEED_METHOD:MEANING', '_LA:FMAST.ROUNDOFF_FACT:IGF_LOOKUPS_VIEW:IGF_AW_ROUND_OFF:MEANING', '_LA:FMAST.REPLACE_FC:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING', '_LA:FMAST.ALLOW_OVERAWARD:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING', '_LA:FMAST.PCKG_AWD_STAT:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING', '_LA:FMAST.ORG_RECORD_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.DISB_RECORD_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.PROM_NOTE_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.MIN_NUM_DISB , FMAST.MAX_NUM_DISB , FMAST.FEE_TYPE , FMAST.TOTAL_OFFERED , FMAST.TOTAL_ACCEPTED , FMAST.TOTAL_DECLINED , FMAST.TOTAL_REVOKED , FMAST.TOTAL_CANCELLED , FMAST.TOTAL_DISBURSED , FMAST.TOTAL_COMMITTED , FMAST.COMMITTED_AMT , FMAST.DISBURSED_AMT , FMAST.AWD_NOTICE_TXT , FMAST.DISB_VERF_DA , FMAST.FUND_EXP_DA , FMAST.NSLDS_DISB_DA , FMAST.DISB_EXP_DA , '_LA:FMAST.FUND_RECV_REQD:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.SHOW_ON_BILL:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.BILL_DESC , FMAST.CREDIT_TYPE_ID , FMAST.GOVT_SHARE_PERCT, FMAST.THRESHOLD_PERCT , FMAST.THRESHOLD_VALUE , FMAST.MAX_HR_RATE, FMAST.MIN_HR_RATE, '_LA:FMAST.SALARY_BASED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.SPNSR_REF_NUM, FMAST.SPNSR_FEE_TYPE, FMAST.MIN_CREDIT_POINTS, FMAST.GROUP_ID GROUP_ID, PIG.DESCRIPTION, '_LA:FMAST.VER_APP_STAT_OVERRIDE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.GIFT_AID:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.SEND_WITHOUT_DOC:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', CI.ALTERNATE_CODE, CI.DESCRIPTION, HZ.PARTY_NUMBER, HZ.PARTY_NAME, FCAT.FUND_TYPE, '_LA:FCAT.FUND_SOURCE:IGF_LOOKUPS_VIEW:IGF_AW_FUND_SOURCE:MEANING', '_LA:FCAT.FED_FUND_CODE:IGF_LOOKUPS_VIEW:IGF_AW_FED_FUND:MEANING', '_LA:FCAT.SYS_FUND_TYPE:IGF_LOOKUPS_VIEW:IGF_AW_SYS_FUND_TYPE:MEANING', '_DF:IGF:IGF_AW_FUND_MAST_ALL_FLEX:FMAST', '_DF:IGF:IGF_SP_FUND_MAST_SPNSR_FLEX:FMAST', '_LA:FMAST.VIEW_ONLY_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.ACCEPT_LESS_AMT_FLAG, '_LA:FMAST.ALLOW_INC_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.MIN_INCREASE_AMT, '_LA:FMAST.ALLOW_DEC_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.MIN_DECREASE_AMT, '_LA:FMAST.ALLOW_DECLN_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.STATUS_AFTER_DECLINE:IGF_LOOKUPS_VIEW:IGF_AW_AWD_STAT_POST_DECL:MEANING', FUND_INFORMATION_TXT, FMAST.CI_CAL_TYPE, FMAST.CI_SEQUENCE_NUMBER, FMAST.PARTY_ID, FMAST.FUND_ID, FMAST.CREATED_BY , FMAST.CREATION_DATE , FMAST.LAST_UPDATED_BY , FMAST.LAST_UPDATE_DATE FROM IGF_AW_FUND_MAST_ALL FMAST, IGS_CA_INST_ALL CI, IGF_AW_FUND_CAT_ALL FCAT, HZ_PARTIES HZ, IGS_PE_PERSID_GROUP_ALL PIG WHERE FMAST.CI_CAL_TYPE = CI.CAL_TYPE AND FMAST.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND FMAST.FUND_CODE = FCAT.FUND_CODE (+) AND FMAST.PARTY_ID = HZ.PARTY_ID (+) AND FMAST.GROUP_ID = PIG.GROUP_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT FMAST.FUND_CODE
, FMAST.DESCRIPTION
, '_LA:FMAST.DISCONTINUE_FUND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.ENTITLEMENT:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.AUTO_PKG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.SELF_HELP:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.ALLOW_MAN_PKG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.UPDATE_NEED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.DISBURSE_FUND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.AVAILABLE_AMT
, FMAST.OFFERED_AMT
, FMAST.PENDING_AMT
, FMAST.ACCEPTED_AMT
, FMAST.DECLINED_AMT
, FMAST.CANCELLED_AMT
, FMAST.REMAINING_AMT
, FMAST.ENROLLMENT_STATUS
, '_LA:FMAST.PRN_AWARD_LETTER:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.OVER_AWARD_AMT
, FMAST.OVER_AWARD_PERCT
, FMAST.MIN_AWARD_AMT
, FMAST.MAX_AWARD_AMT
, FMAST.MAX_YEARLY_AMT
, FMAST.MAX_LIFE_AMT
, FMAST.MAX_LIFE_TERM
, '_LA:FMAST.FM_FC_METHD:IGF_LOOKUPS_VIEW:IGF_AW_NEED_METHOD:MEANING'
, '_LA:FMAST.ROUNDOFF_FACT:IGF_LOOKUPS_VIEW:IGF_AW_ROUND_OFF:MEANING'
, '_LA:FMAST.REPLACE_FC:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING'
, '_LA:FMAST.ALLOW_OVERAWARD:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING'
, '_LA:FMAST.PCKG_AWD_STAT:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING'
, '_LA:FMAST.ORG_RECORD_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.DISB_RECORD_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.PROM_NOTE_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.MIN_NUM_DISB
, FMAST.MAX_NUM_DISB
, FMAST.FEE_TYPE
, FMAST.TOTAL_OFFERED
, FMAST.TOTAL_ACCEPTED
, FMAST.TOTAL_DECLINED
, FMAST.TOTAL_REVOKED
, FMAST.TOTAL_CANCELLED
, FMAST.TOTAL_DISBURSED
, FMAST.TOTAL_COMMITTED
, FMAST.COMMITTED_AMT
, FMAST.DISBURSED_AMT
, FMAST.AWD_NOTICE_TXT
, FMAST.DISB_VERF_DA
, FMAST.FUND_EXP_DA
, FMAST.NSLDS_DISB_DA
, FMAST.DISB_EXP_DA
, '_LA:FMAST.FUND_RECV_REQD:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.SHOW_ON_BILL:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.BILL_DESC
, FMAST.CREDIT_TYPE_ID
, FMAST.GOVT_SHARE_PERCT
, FMAST.THRESHOLD_PERCT
, FMAST.THRESHOLD_VALUE
, FMAST.MAX_HR_RATE
, FMAST.MIN_HR_RATE
, '_LA:FMAST.SALARY_BASED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.SPNSR_REF_NUM
, FMAST.SPNSR_FEE_TYPE
, FMAST.MIN_CREDIT_POINTS
, FMAST.GROUP_ID GROUP_ID
, PIG.DESCRIPTION
, '_LA:FMAST.VER_APP_STAT_OVERRIDE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.GIFT_AID:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.SEND_WITHOUT_DOC:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, FCAT.FUND_TYPE
, '_LA:FCAT.FUND_SOURCE:IGF_LOOKUPS_VIEW:IGF_AW_FUND_SOURCE:MEANING'
, '_LA:FCAT.FED_FUND_CODE:IGF_LOOKUPS_VIEW:IGF_AW_FED_FUND:MEANING'
, '_LA:FCAT.SYS_FUND_TYPE:IGF_LOOKUPS_VIEW:IGF_AW_SYS_FUND_TYPE:MEANING'
, '_DF:IGF:IGF_AW_FUND_MAST_ALL_FLEX:FMAST'
, '_DF:IGF:IGF_SP_FUND_MAST_SPNSR_FLEX:FMAST'
, '_LA:FMAST.VIEW_ONLY_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.ACCEPT_LESS_AMT_FLAG
, '_LA:FMAST.ALLOW_INC_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.MIN_INCREASE_AMT
, '_LA:FMAST.ALLOW_DEC_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.MIN_DECREASE_AMT
, '_LA:FMAST.ALLOW_DECLN_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.STATUS_AFTER_DECLINE:IGF_LOOKUPS_VIEW:IGF_AW_AWD_STAT_POST_DECL:MEANING'
, FUND_INFORMATION_TXT
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, FMAST.PARTY_ID
, FMAST.FUND_ID
, FMAST.CREATED_BY
, FMAST.CREATION_DATE
, FMAST.LAST_UPDATED_BY
, FMAST.LAST_UPDATE_DATE
FROM IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL CI
, IGF_AW_FUND_CAT_ALL FCAT
, HZ_PARTIES HZ
, IGS_PE_PERSID_GROUP_ALL PIG
WHERE FMAST.CI_CAL_TYPE = CI.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND FMAST.FUND_CODE = FCAT.FUND_CODE (+)
AND FMAST.PARTY_ID = HZ.PARTY_ID (+)
AND FMAST.GROUP_ID = PIG.GROUP_ID (+) WITH READ ONLY