Product: | IGF - Financial Aid |
---|---|
Description: | Target group master |
Implementation/DBA Data: | APPS.IGF_AW_TARGET_GRP_V |
SELECT TGRP.ROW_ID
, TGRP.GROUP_CD
, TGRP.DESCRIPTION
, TGRP.ACTIVE
, TGRP.MAX_GRANT_AMT
, TGRP.MAX_GRANT_PERCT
, TGRP.MAX_GRANT_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_GRANT_PERCT_FACT)
, TGRP.MAX_LOAN_AMT
, TGRP.MAX_LOAN_PERCT
, TGRP.MAX_LOAN_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_LOAN_PERCT_FACT)
, TGRP.MAX_WORK_AMT
, TGRP.MAX_WORK_PERCT
, TGRP.MAX_WORK_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_WORK_PERCT_FACT)
, TGRP.MAX_SHELP_AMT
, TGRP.MAX_SHELP_PERCT
, TGRP.MAX_SHELP_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_SHELP_PERCT_FACT)
, TGRP.MAX_GAP_AMT
, TGRP.MAX_GAP_PERCT
, TGRP.MAX_GAP_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_GAP_PERCT_FACT)
, TGRP.USE_FIXED_COSTS
, TGRP.MAX_AID_PKG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TGRP.CREATED_BY
, TGRP.CREATION_DATE
, TGRP.LAST_UPDATED_BY
, TGRP.LAST_UPDATE_DATE
, TGRP.LAST_UPDATE_LOGIN
, TGRP.TGRP_ID
, TGRP.CAL_TYPE
, TGRP.SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, TGRP.MAX_GIFT_AMT
, TGRP.MAX_GIFT_PERCT
, TGRP.MAX_GIFT_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_GIFT_PERCT_FACT)
, TGRP.MAX_SCHLRSHP_AMT
, TGRP.MAX_SCHLRSHP_PERCT
, TGRP.MAX_SCHLRSHP_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_SCHLRSHP_PERCT_FACT)
, TGRP.ADPLANS_ID
, ADPLANS.AWD_DIST_PLAN_CD
, ADPLANS.AWD_DIST_PLAN_CD_DESC
, ADPLANS.DIST_PLAN_METHOD_CODE
FROM IGF_AW_TARGET_GRP TGRP
, IGS_CA_INST CI
, IGF_AW_AWD_DIST_PLANS ADPLANS
WHERE CI.CAL_TYPE = TGRP.CAL_TYPE
AND CI.SEQUENCE_NUMBER = TGRP.SEQUENCE_NUMBER
AND TGRP.ADPLANS_ID = ADPLANS.ADPLANS_ID(+)