PSB Budget Group Hierarchy Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Budget Group Hierarchy Listing (XML)
Short Name: PSBRPBGH_XML
DB package: PSB_PSBRPBGH_XMLP_PKG
SELECT bg.budget_group_id budget_group_id2,
             bg.name Top_Budget_Group,
             sob.name set_of_books_name
FROM    psb_budget_groups  bg,
             gl_sets_of_books    sob
WHERE bg.set_of_books_id     = NVL(:p_set_of_books_id, bg.set_of_books_id)
AND      bg.budget_group_id    = NVL(:p_budget_group_id, bg.budget_group_id)
AND      bg.budget_group_type = 'R'
AND      bg.root_budget_group  = 'Y'
AND      sob.set_of_books_id = bg.set_of_books_id
AND      effective_start_date <= :lp_effective_date
AND      ( effective_end_date IS NULL
               OR
               effective_end_date >= :lp_effective_date
             )
ORDER BY sob.name,bg.budget_group_id
Parameter NameSQL textValidation
Ledger
 
LOV Oracle
Budget Group Name
 
LOV Oracle
Effective Date
 
Date
Download
Related Blitz Reports
PSB Distribution Rule Listing PSB Constraints Listing PSB Allocation Rules Listing PSB Budget Revisions Transaction Report By Responsibility PSB Parameter Listing PSB Budget Revisions Transaction PSB Stage Variance Report for Account by Responsibility PSB Stage Variance Report for Account PSB Standard Budget Items Listing
Blitz Report™