APPS.PA_CLIENT_EXTN_PROJ_STATUS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 74

                 select project_system_status_code
                 into l_system_status_code
                 from pa_project_statuses
                 where project_status_code = X_new_proj_status_code;

Line: 107

                   assigned to the project, by doing a SELECT on the
                   pa_project_classifications table.
                   If the class category is not assigned to the project
                   you would then code the message handling as follows.

                   PA_UTILS.Add_Message
                      (p_app_short_name	=> 'PA',
		       p_msg_name  => 'PA_SPEC_CLASS_CATEGORY_REQD',
		       p_token1	   => 'CLASS_CATEGORY',
		       p_value1    => );

Line: 270

select NVL(enable_project_wf_flag,'N')
FROM pa_project_types_all   -- Bug#3807805 : Modified pa_project_types to pa_project_types_all
WHERE project_type = x_project_type
and  org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805

Line: 280

SELECT
	PPT.org_id,
	NVL(PPT.enable_project_wf_flag,'N')
FROM
	PA_PROJECT_TYPES_ALL	PPT,
	PA_PROJECTS_ALL		PPA
WHERE
	PPA.org_id		=	PPT.org_id		AND
	PPA.project_type	=	PPT.project_type	AND
	PPA.project_id		=	x_project_id		AND
	PPT.project_type	=	x_project_type;

Line: 295

select NVL(enable_wf_flag,'N')
FROM pa_project_statuses
WHERE project_status_code = x_project_status_code;

Line: 311

          	select org_id into PA_PROJECT_REQUEST_PVT.G_ORG_ID from pa_project_types where project_type = x_project_type;