DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on PA_PROJECTS_ALL

Line 476: pa_projects_all P,

472: X_CC_OK
473: FROM HR_ORGANIZATION_INFORMATION PLE,
474: HR_ORGANIZATION_INFORMATION RLE,
475: pa_project_types_all PT,
476: pa_projects_all P,
477: pa_implementations_all iprv,
478: pa_implementations_all irecv
479: WHERE P.project_type = PT.project_type
480: AND NVL(P.template_flag, 'N') <> 'Y'

Line 2389: pa_projects_all proj,

2385: INTO l_proj_name_number,
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