APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_TYPES_ALL

Line 487: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

483: where project_id = c_project_id
484: and project_role_type='PROJECT MANAGER';
485:
486: l_proj_status pa_projects_all.project_status_code%TYPE;
487: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
488: l_prj_mgr_count NUMBER;
489: /* End of code for bug #2111806. */
490:
491: -- 4193743 Added below local variables

Line 597: pa_project_types_all pt

593: IS
594: SELECT 'Y'
595: FROM
596: pa_projects_all p,
597: pa_project_types_all pt
598: WHERE
599: p.project_id = p_project_id AND
600: pt.project_type_class_code = 'CONTRACT' AND
601: p.project_type = pt.project_type AND

Line 10262: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

10258: where project_id = c_project_id
10259: and project_role_type='PROJECT MANAGER';
10260:
10261: l_proj_status pa_projects_all.project_status_code%TYPE;
10262: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
10263: l_prj_mgr_count NUMBER;
10264: /* End of code for bug #2111806. */
10265:
10266: l_old_cust_top_task_flag varchar2(1); -- 4188765 Added local variable

Line 10523: pa_project_types_all pt

10519: IS
10520: SELECT 'Y'
10521: FROM
10522: pa_projects_all p,
10523: pa_project_types_all pt
10524: WHERE
10525: p.project_id = p_project_id AND
10526: pt.project_type_class_code = 'CONTRACT' AND
10527: p.project_type = pt.project_type AND