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
| Parameter | Type | List of values SQL |
|---|---|---|
| Closing Status | LOV Oracle |