APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_TYPES_ALL

Line 488: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

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

Line 630: pa_project_types_all pt

626: IS
627: SELECT 'Y'
628: FROM
629: pa_projects_all p,
630: pa_project_types_all pt
631: WHERE
632: p.project_id = p_project_id AND
633: pt.project_type_class_code = 'CONTRACT' AND
634: p.project_type = pt.project_type AND

Line 10524: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

10520: where project_id = c_project_id
10521: and project_role_type='PROJECT MANAGER';
10522:
10523: l_proj_status pa_projects_all.project_status_code%TYPE;
10524: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
10525: l_prj_mgr_count NUMBER;
10526: /* End of code for bug #2111806. */
10527:
10528: l_old_cust_top_task_flag varchar2(1); -- 4188765 Added local variable

Line 10785: pa_project_types_all pt

10781: IS
10782: SELECT 'Y'
10783: FROM
10784: pa_projects_all p,
10785: pa_project_types_all pt
10786: WHERE
10787: p.project_id = p_project_id AND
10788: pt.project_type_class_code = 'CONTRACT' AND
10789: p.project_type = pt.project_type AND