VIEW: APPS.IGF_AW_FISAP_SECTION_VI_V

Source

View Text - Preformatted

SELECT A.ROWID, A.CATEGORY_ID , A.FISAP_SECTION, 'NON_PROFESSIONAL', A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, B.MINVALUE, B.MAXVALUE, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL', 'PRK' , A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, B.MINVALUE, B.MAXVALUE), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'NON_PROFESSIONAL', 'PRK' , A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, B.MINVALUE, B.MAXVALUE), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL', 'FSEOG', A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, B.MINVALUE, B.MAXVALUE), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'NON_PROFESSIONAL', 'FSEOG' , A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, B.MINVALUE, B.MAXVALUE), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL', 'FWS' , A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, B.MINVALUE, B.MAXVALUE), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'NON_PROFESSIONAL', 'FWS' , A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, B.MINVALUE, B.MAXVALUE), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL', 'UNDUPL' , A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, B.MINVALUE, B.MAXVALUE) FROM IGF_AW_FISAP_REPSET A, IGF_AW_FI_INC_LEVEL B WHERE A.CATEGORY_ID = B.CATEGORY_ID AND A.FISAP_SECTION ='SECTION_VI' UNION SELECT A.ROWID, 0, 'SECTION_VI', 'PROFESSIONAL', 'I', '3', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL', 'PRK' , 'I', '3', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'PROFESSIONAL', 'PRK' , 'I', '3', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL', 'FSEOG' , 'I', '3', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'PROFESSIONAL', 'FSEOG' , 'I', '3', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL', 'FWS' , 'I', '3', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_FUND( 'PROFESSIONAL', 'FWS' , 'I', '3', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL', 'UNDUPL' , 'I', '3', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0) FROM IGF_AW_FISAP_REPSET A WHERE A.FISAP_SECTION = 'SECTION_VI' UNION SELECT A.ROWID, 0 , 'SECTION_VI', 'AUTO_ZERO', 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO', 'PRK' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'AUTO_ZERO', 'PRK' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO', 'FSEOG' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'AUTO_ZERO', 'FSEOG' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO', 'FWS' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'AUTO_ZERO', 'FWS' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO', 'UNDUPL' , A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0) FROM IGF_AW_FISAP_REPSET A WHERE A.FISAP_SECTION = 'SECTION_VI' UNION SELECT A.ROWID, 0, 'SECTION_VI', 'LESS_THAN_FULL_TIME', 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME', 'PRK' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'LESS_THAN_FULL_TIME', 'PRK' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME', 'FSEOG' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'LESS_THAN_FULL_TIME', 'FSEOG' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME', 'FWS' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'LESS_THAN_FULL_TIME', 'FWS' , 'B', 'GRAD_UGRAD', A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0), IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME', 'UNDUPL' , A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0) FROM IGF_AW_FISAP_REPSET A WHERE A.FISAP_SECTION = 'SECTION_VI'

View Text - HTML Formatted

SELECT A.ROWID
, A.CATEGORY_ID
, A.FISAP_SECTION
, 'NON_PROFESSIONAL'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL'
, 'PRK'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'NON_PROFESSIONAL'
, 'PRK'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL'
, 'FSEOG'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'NON_PROFESSIONAL'
, 'FSEOG'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL'
, 'FWS'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'NON_PROFESSIONAL'
, 'FWS'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL'
, 'UNDUPL'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
FROM IGF_AW_FISAP_REPSET A
, IGF_AW_FI_INC_LEVEL B
WHERE A.CATEGORY_ID = B.CATEGORY_ID
AND A.FISAP_SECTION ='SECTION_VI' UNION SELECT A.ROWID
, 0
, 'SECTION_VI'
, 'PROFESSIONAL'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL'
, 'PRK'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'PROFESSIONAL'
, 'PRK'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL'
, 'FSEOG'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'PROFESSIONAL'
, 'FSEOG'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL'
, 'FWS'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND( 'PROFESSIONAL'
, 'FWS'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL'
, 'UNDUPL'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
FROM IGF_AW_FISAP_REPSET A
WHERE A.FISAP_SECTION = 'SECTION_VI' UNION SELECT A.ROWID
, 0
, 'SECTION_VI'
, 'AUTO_ZERO'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO'
, 'PRK'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'AUTO_ZERO'
, 'PRK'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO'
, 'FSEOG'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'AUTO_ZERO'
, 'FSEOG'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO'
, 'FWS'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'AUTO_ZERO'
, 'FWS'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO'
, 'UNDUPL'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
FROM IGF_AW_FISAP_REPSET A
WHERE A.FISAP_SECTION = 'SECTION_VI' UNION SELECT A.ROWID
, 0
, 'SECTION_VI'
, 'LESS_THAN_FULL_TIME'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME'
, 'PRK'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'LESS_THAN_FULL_TIME'
, 'PRK'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME'
, 'FSEOG'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'LESS_THAN_FULL_TIME'
, 'FSEOG'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME'
, 'FWS'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'LESS_THAN_FULL_TIME'
, 'FWS'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME'
, 'UNDUPL'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
FROM IGF_AW_FISAP_REPSET A
WHERE A.FISAP_SECTION = 'SECTION_VI'