DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on PA_PROJECT_STATUSES

Line 2390: pa_project_statuses ps

2386: l_project_id
2387: FROM --pa_resources_denorm res,
2388: pa_project_assignments asgmt,
2389: pa_projects_all proj,
2390: pa_project_statuses ps
2391: WHERE --trunc(sysdate) between trunc(res.resource_effective_start_date)
2392: -- and trunc(res.resource_effective_end_date)
2393: --AND res.resource_id = asgmt.resource_id
2394: --AND res.resource_id = p_resource_id