PA Projects Periods

select  s.meaning status
,     	p.period_name
,	p.start_date
,	p.end_date
from 	pa_lookups s
,	pa_periods p
where	p.status = s.lookup_code
and	s.lookup_type = 'CLOSING STATUS'
and	p.status = nvl(:p_status_code,p.status)
order by p.start_date desc