PA Projects Periods

Description

Categories
BI Publisher
Application
Projects
Source
IMP: Projects Periods (XML)
Short Name
PAXRWPST_XML
DB package
PA_PAXRWPST_XMLP_PKG

SQL 11 lines

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

Parameters 1

ParameterTypeList of values SQL
Closing StatusLOV Oracle