ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F41C3869E053B46B63588994Y 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 PSB PSBRPBGH_XML US PSB Budget Group Hierarchy Listing Application: Public Sector Budgeting (Obsolete) Source: Budget Group Hierarchy Listing (XML) Short Name: PSBRPBGH_XML DB package: PSB_PSBRPBGH_XMLP_PKG BI Publisher :lp_effective_date :p_budget_group_id :p_set_of_books_id 1 10 :p_set_of_books_id LOV Oracle PSB_SET_OF_BOOKS Y select set_of_books_id id, name value, null description from gl_sets_of_books order by name US Ledger 2 20 :p_budget_group_id LOV Oracle PSB_TOP_BUDGET_GROUP_BY_SOB Y select budget_group_id id, name value, null description from psb_budget_groups where root_budget_group='Y' and budget_group_type='R' and set_of_books_id= nvl(:$flex$.psb_set_of_books,set_of_books_id) order by name US Budget Group Name 3 30 :p_effective_date Date US Effective Date