DBA Data[Home] [Help]

APPS.PA_PROJ_TEMPLATE_SETUP_UTILS dependencies on PA_PROJECTS_V

Line 665: from pa_projects_v --cannot replace with project_all bcoz project name user enters must be validated with secuured view.

661: l_ndf_exception NUMBER; --to indicate which part of the code raised no_data_found exception
662:
663: cursor c IS
664: select project_id
665: from pa_projects_v --cannot replace with project_all bcoz project name user enters must be validated with secuured view.
666: where name = p_project_name; -- removed the UPPER function for perf. bug 2786121
667:
668: BEGIN
669:

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