[Home] [Help]
View: PSBBV_ALLOCATION_PERCENTAGES
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT 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))
, PAP.ALLOCATION_RULE_PERCENT_ID
, PAP.ALLOCATION_RULE_ID
, PAP.LAST_UPDATE_DATE
, PAP.LAST_UPDATED_BY
, PAP.CREATED_BY
, PAP.CREATION_DATE
FROM PSB_ALLOCRULE_PERCENTS PAP
, PSB_ENTITY PE
WHERE PE.ENTITY_ID = PAP.ALLOCATION_RULE_ID
AND PE.ENTITY_TYPE = 'ALLOCRULE' GROUP BY PAP.ALLOCATION_RULE_ID
, PAP.ALLOCATION_RULE_PERCENT_ID
, PAP.PERIOD_NUM
, PAP.LAST_UPDATE_DATE
, PAP.LAST_UPDATED_BY
, PAP.CREATED_BY
, PAP.CREATION_DATE WITH READ ONLY
Columns
Name |
PERIOD_NUMBER |
MONTHLY |
QUARTERLY |
SEMI_ANNUAL |
ALLOCATION_PERCENTAGE_ID |
ALLOCATION_RULE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |