PA Maintain Project Resources

Description

Categories
BI Publisher
Application
Projects
Source
PRC: Maintain Project Resources (XML)
Short Name
PARCPRJR_XML
DB package
PA_PARCPRJR_XMLP_PKG

SQL 12 lines

select	res.resource_id,
	res.name,
	ou.resource_organization_id,
	substr(hrorg.name,1,60)  name1,
	ou.resource_effective_start_date,
	decode(ou.resource_effective_end_date, to_date('31-12-4712', 'DD-MM-YYYY'), to_date(null), ou.resource_effective_end_date) resource_effective_end_date
from pa_resources res, pa_resources_denorm ou, hr_all_organization_units hrorg
where res.resource_id = ou.resource_id(+)
and ou.resource_organization_id = hrorg.organization_id(+)
and (decode(res.request_id,:p_conc_request_id,res.request_id,NULL)  = :p_conc_request_id
or decode(ou.request_id,:p_conc_request_id,ou.request_id,NULL)  = :p_conc_request_id)

Parameters 10

ParameterTypeList of values SQL
Selection OptionLOV Oracle
From Employee NumberLOV Oracle
To Employee NumberLOV Oracle
OrganizationLOV Oracle
Organization HierarchyLOV Oracle
Starting OrganizationLOV Oracle
Update Existing Resource InformationLOV Oracle
Pull Terminated ResourcesLOV Oracle
Termination Start DateDate
Person TypeLOV Oracle