PSB Budget Calendar Listing

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