ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F41F3869E053B46B63588994 SELECT c.name cname, c.description cdesc, y.name ytype, p.name yshort, p.start_date, p.end_date, fnd.meaning, p.budget_period_id FROM psb_budget_year_types y, psb_budget_calendars c, psb_budget_periods p, fnd_lookups fnd WHERE p.budget_calendar_id = c.budget_calendar_id AND p.budget_year_type_id = y.budget_year_type_id AND fnd.lookup_type = 'PSB_PERIOD_DISTRIBUTION_TYPES' AND fnd.lookup_code = p.period_distribution_type AND p.budget_period_type = 'Y' AND (:p_budget_calendar_id is null OR c.budget_calendar_id = :p_budget_calendar_id) ORDER BY c.name, y.sequence_number Y PSB PSBRPCAL_XML US PSB Budget Calendar Listing Application: Public Sector Budgeting (Obsolete) Source: Budget Calendar Listing (XML) Short Name: PSBRPCAL_XML DB package: PSB_PSBRPCAL_XMLP_PKG BI Publisher :p_budget_calendar_id 1 10 :p_budget_calendar_id LOV Oracle PSB_SRS_CALENDAR Y select budget_calendar_id id, name value, description description from psb_budget_calendars order by name US Calendar Name