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
Source: PRC: Maintain Project Resources (XML)
Short Name: PARCPRJR_XML
DB package: PA_PARCPRJR_XMLP_PKG
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) |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Selection Option | LOV Oracle | ||
| From Employee Number | LOV Oracle | ||
| To Employee Number | LOV Oracle | ||
| Organization | LOV Oracle | ||
| Organization Hierarchy | LOV Oracle | ||
| Starting Organization | LOV Oracle | ||
| Update Existing Resource Information | LOV Oracle | ||
| Pull Terminated Resources | LOV Oracle | ||
| Termination Start Date | Date | ||
| Person Type | LOV Oracle |