APPS.PA_PROJ_TEMPLATE_SETUP_UTILS dependencies on PA_PROJECTS_ALL

Line 701: FROM pa_projects_all --replaced pa_projects_v with pa_projects_all for perf. bug 2786121

697: -- ID is not empty;
698: IF (p_check_id_flag = 'Y') THEN
699: SELECT project_id
700: INTO x_project_id
701: FROM pa_projects_all --replaced pa_projects_v with pa_projects_all for perf. bug 2786121
702: WHERE project_id = p_project_id;
703: ELSIF (p_check_id_flag = 'N') THEN
704: x_project_id := p_project_id;
705: ELSIF (p_check_id_flag = 'A') THEN

Line 862: FROM PA_PROJECTS_ALL

858:
859: CURSOR get_template_id
860: IS
861: SELECT created_from_project_id
862: FROM PA_PROJECTS_ALL
863: WHERE project_id = p_project_id;
864:
865: CURSOR cur_pa_proj_options(c_project_id NUMBER)
866: IS

Line 875: FROM PA_PROJECTS_ALL

871:
872: CURSOR check_template
873: IS
874: SELECT 'Y'
875: FROM PA_PROJECTS_ALL
876: WHERE project_id = p_project_id
877: AND template_flag = 'Y';
878:
879: BEGIN