DBA Data[Home] [Help]

APPS.PA_FCST_GLOBAL dependencies on PA_PROJECT_TYPES_ALL

Line 335: pa_project_types_all pr2

331:
332: SELECT pr2.project_type_class_code
333: INTO l_project_type_class
334: FROM pa_projects_all pr1,
335: pa_project_types_all pr2
336: WHERE pr1.project_id = p_project_id
337: AND pr2.project_type = pr1.project_type
338: AND nvl(pr1.org_id,-99)=nvl(pr2.org_id,-99);
339:

Line 747: pa_project_types_all pr2

743:
744: SELECT pr2.project_type_class_code
745: INTO l_project_type_class
746: FROM pa_projects_all pr1,
747: pa_project_types_all pr2
748: WHERE pr1.project_id = p_project_id
749: AND pr2.project_type = pr1.project_type
750: AND nvl(pr1.org_id,-99)=nvl(pr2.org_id,-99);
751: