[Home] [Help]
View: PSB_ALLOCRULE_PERCENTS_V
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PAP.ALLOCATION_RULE_ID
, PAP.PERIOD_NUM
, SUM(DECODE(PAP.NUMBER_OF_PERIODS
, 12
, PAP.PERCENT))
, SUM(DECODE(PAP.NUMBER_OF_PERIODS
, 4
, PAP.PERCENT))
, SUM(DECODE(PAP.NUMBER_OF_PERIODS
, 2
, PAP.PERCENT))
FROM PSB_ALLOCRULE_PERCENTS PAP GROUP BY PAP.ALLOCATION_RULE_ID
, PAP.PERIOD_NUM
Columns
Name |
ALLOCATION_RULE_ID |
PERIOD_NUM |
MONTHLY |
QUARTERLY |
SEMI_ANNUAL |