PSB Budget Group Hierarchy Listing

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 Name SQL text Validation
Effective Date
 
Date
Budget Group Name
 
LOV Oracle
Ledger
 
LOV Oracle