APPS.PJM_SEIBAN_PKG SQL Statements

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

Line: 39

  select project_id
  from   pa_projects_all
  where  segment1 = X_project_number
  and    ( X_project_id is null or project_id <> X_project_id )
  union all
  select project_id
  from   pjm_seiban_numbers
  where  project_number = X_project_number
  and    ( X_project_id is null or project_id <> X_project_id );

Line: 79

  select project_id
  from   pa_projects_all
  where  name = X_project_name
  and    ( X_project_id is null or project_id <> X_project_id )
  union all
  select project_id
  from   pjm_seiban_numbers
  where  project_name = X_project_name
  and    ( X_project_id is null or project_id <> X_project_id );

Line: 213

 select org_id into l_org_id
 from pa_projects_all
 where project_id = X_project_created_from;

Line: 216

 select application_id into l_resp_appl_id
 from fnd_responsibility where responsibility_id = l_resp_id;

Line: 402

  SELECT wf_status_code
  FROM   pa_projects
  WHERE  project_id = C_project_id;

Line: 466

    SELECT segment1
    INTO   L_Project_Num
    FROM   PA_Projects
    WHERE  Project_ID = L_Project_ID;

Line: 499

      SELECT task_id
      INTO   L_Task_ID
      FROM   PA_Tasks
      WHERE  Project_ID = L_Project_ID
      AND (  Task_Number = L_Task_Num
          OR Task_Name   = L_Task_num )
      AND    rownum = 1;