PA Projects Periods

Description
Categories: BI Publisher, Financials
Application: Projects
Source: IMP: Projects Periods (XML)
Short Name: PAXRWPST_XML
DB package: PA_PAXRWPST_XMLP_PKG
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
Parameter Name SQL text Validation
Closing Status
 
LOV Oracle