APPS.PA_PROJECT_SUBTEAM_UTILS SQL Statements

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

Line: 28

			SELECT project_subteam_id
	      	  	INTO   x_subteam_id
	        	FROM   pa_project_subteams
	        	WHERE  project_subteam_id = x_subteam_id
                        AND    object_type = decode(p_object_type, FND_API.G_MISS_CHAR, object_type, null, object_type, p_object_type)  -- 5130421
                        AND    object_id = decode(p_object_id, FND_API.G_MISS_NUM, object_id, null, object_id, p_object_id)  -- 5130421
                        ;

Line: 43

            SELECT project_subteam_id
                INTO   x_subteam_id
                FROM   pa_project_subteams
                WHERE  name = p_subteam_name
                AND    object_type = p_object_type
                AND    object_id = p_object_id;

Line: 53

		SELECT project_subteam_id
        	INTO   x_subteam_id
        	FROM   pa_project_subteams
        	WHERE  name = p_subteam_name
		AND    object_type = p_object_type
		AND    object_id = p_object_id;

Line: 85

    select project_id
     from pa_projects_all
    where name = p_object_name;

Line: 90

   select team_template_id
   from pa_team_templates
   where team_template_name=p_object_name;