View: IGFBV_FEDERAL_NEED_DETAILS

View Text

SELECT DISTINCT PE.PARTY_NAME
, PE.PARTY_NUMBER
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, LD.ALTERNATE_CODE
, LD.DESCRIPTION
, LD.START_DT
, LD.END_DT
, IGF_AP_EFC_CALC.GET_EFC_NO_OF_MONTHS(LD.END_DT
, COAIT.BASE_ID )
, IGF_AP_GEN.GET_CUMULATIVE_COA_AMT(LD.START_DT
, COAIT.BASE_ID)
, NVL(DECODE(BASE.AWARD_FMLY_CONTRIBUTION_TYPE
, '2'
, DECODE ( IGF_AP_EFC_CALC.GET_EFC_NO_OF_MONTHS(LD.END_DT
, COAIT.BASE_ID )
, 1
, SEC_ALTERNATE_MONTH_1
, 2
, SEC_ALTERNATE_MONTH_2
, 3
, SEC_ALTERNATE_MONTH_3
, 4
, SEC_ALTERNATE_MONTH_4
, 5
, SEC_ALTERNATE_MONTH_5
, 6
, SEC_ALTERNATE_MONTH_6
, 7
, SEC_ALTERNATE_MONTH_7
, 8
, SEC_ALTERNATE_MONTH_8
, 9
, SECONDARY_EFC
, 10
, SEC_ALTERNATE_MONTH_10
, 11
, SEC_ALTERNATE_MONTH_11
, 12
, SEC_ALTERNATE_MONTH_12 )
, DECODE (IGF_AP_EFC_CALC.GET_EFC_NO_OF_MONTHS(LD.END_DT
, COAIT.BASE_ID)
, 1
, PRIMARY_ALTERNATE_MONTH_1
, 2
, PRIMARY_ALTERNATE_MONTH_2
, 3
, PRIMARY_ALTERNATE_MONTH_3
, 4
, PRIMARY_ALTERNATE_MONTH_4
, 5
, PRIMARY_ALTERNATE_MONTH_5
, 6
, PRIMARY_ALTERNATE_MONTH_6
, 7
, PRIMARY_ALTERNATE_MONTH_7
, 8
, PRIMARY_ALTERNATE_MONTH_8
, 9
, PRIMARY_EFC
, 10
, PRIMARY_ALTERNATE_MONTH_10
, 11
, PRIMARY_ALTERNATE_MONTH_11
, 12
, PRIMARY_ALTERNATE_MONTH_12 ) )
, 0)
, BASE.PERSON_ID
FROM HZ_PARTIES PE
, IGF_AP_ISIR_MATCHED_ALL ISIRM
, IGF_AP_FA_BASE_REC_ALL BASE
, IGF_AW_COA_ITM_TERMS COAIT
, IGS_CA_INST_ALL LD
, IGS_CA_INST_ALL CI
WHERE PE.PARTY_ID = BASE.PERSON_ID
AND BASE.BASE_ID = ISIRM.BASE_ID
AND ISIRM.ACTIVE_ISIR = 'Y'
AND ISIRM.BASE_ID = COAIT.BASE_ID
AND COAIT.LD_CAL_TYPE = LD.CAL_TYPE
AND COAIT.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER
AND BASE.CI_CAL_TYPE = CI.CAL_TYPE
AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY

Columns