DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on PA_PROJECTS_ALL

Line 477: pa_projects_all P,

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

Line 2506: pa_projects_all proj,

2502: INTO l_proj_name_number,
2503: l_project_id
2504: FROM --pa_resources_denorm res,
2505: pa_project_assignments asgmt,
2506: pa_projects_all proj,
2507: pa_project_statuses ps
2508: WHERE --trunc(sysdate) between trunc(res.resource_effective_start_date)
2509: -- and trunc(res.resource_effective_end_date)
2510: --AND res.resource_id = asgmt.resource_id