Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_AW_TARGET_GRP |
SELECT TGRP.ROWID
, TGRP.GROUP_CD
, TGRP.DESCRIPTION
, TGRP.ACTIVE
, TGRP.MAX_GRANT_AMT
, TGRP.MAX_GRANT_PERCT
, TGRP.MAX_GRANT_PERCT_FACT
, TGRP.MAX_LOAN_AMT
, TGRP.MAX_LOAN_PERCT
, TGRP.MAX_LOAN_PERCT_FACT
, TGRP.MAX_WORK_AMT
, TGRP.MAX_WORK_PERCT
, TGRP.MAX_WORK_PERCT_FACT
, TGRP.MAX_SHELP_AMT
, TGRP.MAX_SHELP_PERCT
, TGRP.MAX_SHELP_PERCT_FACT
, TGRP.MAX_GAP_AMT
, TGRP.MAX_GAP_PERCT
, TGRP.MAX_GAP_PERCT_FACT
, TGRP.USE_FIXED_COSTS
, TGRP.MAX_AID_PKG
, NULL
, NULL
, NULL
, TGRP.CREATED_BY
, TGRP.CREATION_DATE
, TGRP.LAST_UPDATED_BY
, TGRP.LAST_UPDATE_DATE
, TGRP.LAST_UPDATE_LOGIN
, TGRP.ORG_ID
, TGRP.TGRP_ID
, TGRP.CAL_TYPE
, TGRP.SEQUENCE_NUMBER
, TGRP.MAX_GIFT_AMT
, TGRP.MAX_GIFT_PERCT
, TGRP.MAX_GIFT_PERCT_FACT
, TGRP.MAX_SCHLRSHP_PERCT
, TGRP.MAX_SCHLRSHP_PERCT_FACT
, TGRP.MAX_SCHLRSHP_AMT
, TGRP.ADPLANS_ID
FROM IGF_AW_TARGET_GRP_ALL TGRP
WHERE NVL (TGRP.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)