APPS.AP_WEB_DB_PA_INT_PKG SQL Statements

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

Line: 12

   select PROJECT_NUMBER
   into   p_project_number
   from   PA_PROJECTS_EXPEND_V
   where  PROJECT_ID = p_project_id;

Line: 39

  select PROJECT_ID, PROJECT_NAME
  into   p_project_id, p_project_name
  from   PA_PROJECTS_EXPEND_V
  where  PROJECT_NUMBER = p_project_number;

Line: 66

	SELECT	task_id, task_name
	INTO	p_task_id, p_task_name
	FROM	pa_tasks_expend_v
	WHERE	project_id = p_proj_id
	AND	task_number = p_task_num;

Line: 93

  select TASK_ID
  into   p_task_id
  from   PA_TASKS_EXPEND_V
  where  PROJECT_ID = p_project_id;

Line: 121

	SELECT	task_id
	INTO	p_task_id
	FROM	pa_tasks_expend_v
	WHERE	project_id = p_proj_id
	AND	task_number = p_task_num;

Line: 149

  select PROJECT_ID
  into   p_project_id
  from   PA_PROJECTS_EXPEND_V
  where  PROJECT_NUMBER = p_project_number;

Line: 174

  select segment1 --project number
  into   l_project_number
  from   PA_PROJECTS_ALL
  where  project_id = p_project_id;

Line: 196

  select segment1, name
  into   p_project_number, p_project_name
  from   pa_projects_all
  where  project_id = p_project_id;