VIEW: APPS.IGF_AW_FISAP_SECTION_II_V

Source

View Text - Preformatted

SELECT A.ROWID , A.CATEGORY_ID , A.FISAP_SECTION, A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, B.MINVALUE, B.MAXVALUE, IGF_AW_GEN_002.GET_SECTIONII_STDNT ( A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, B.MINVALUE, B.MAXVALUE, 'FALSE'), 'N' FROM IGF_AW_FISAP_REPSET A, IGF_AW_FI_INC_LEVEL B WHERE A.CATEGORY_ID = B.CATEGORY_ID AND A.FISAP_SECTION ='SECTION_II' UNION SELECT A.ROWID, A.CATEGORY_ID , A.FISAP_SECTION, A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0, IGF_AW_GEN_002.GET_SECTIONII_STDNT ( A.DEPEND_STAT, A.CLASS_STANDING, A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, 0, 0, 'TRUE'), 'Y' FROM IGF_AW_FISAP_REPSET A WHERE A.FISAP_SECTION = 'SECTION_II'

View Text - HTML Formatted

SELECT A.ROWID
, A.CATEGORY_ID
, A.FISAP_SECTION
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE
, IGF_AW_GEN_002.GET_SECTIONII_STDNT ( A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE
, 'FALSE')
, 'N'
FROM IGF_AW_FISAP_REPSET A
, IGF_AW_FI_INC_LEVEL B
WHERE A.CATEGORY_ID = B.CATEGORY_ID
AND A.FISAP_SECTION ='SECTION_II' UNION SELECT A.ROWID
, A.CATEGORY_ID
, A.FISAP_SECTION
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0
, IGF_AW_GEN_002.GET_SECTIONII_STDNT ( A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0
, 'TRUE')
, 'Y'
FROM IGF_AW_FISAP_REPSET A
WHERE A.FISAP_SECTION = 'SECTION_II'