PA Revenue Categories

Description

Categories
BI Publisher
Application
Projects
Source
IMP: Revenue Categories (XML)
Short Name
PAXRWRVC_XML
DB package
PA_PAXRWRVC_XMLP_PKG

SQL 11 lines

SELECT	et.expenditure_type
,	et.expenditure_category
,	et.revenue_category_code
,	et.start_date_active
,	et.end_date_active
FROM	pa_expenditure_types et 
 WHERE et.revenue_category_code=:LOOKUP_CODE
ORDER BY
	et.expenditure_type
,	et.start_date_active

Parameters 1

ParameterTypeList of values SQL
Revenue CategoryLOV Oracle