APPS.PA_MC_BILLING_PUB SQL Statements

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

Line: 58

          SELECT project_id
            INTO l_project_id
            FROM pa_projects_all
           WHERE segment1 = p_project_number;

Line: 72

        SELECT task_id
          INTO l_task_id
          FROM  pa_tasks
         WHERE  task_number = p_task_number
	 AND    Project_ID  = l_project_id; -- Added for Bug 2675566

Line: 87

        SELECT billing_extension_id
          INTO l_billing_extension_id
          FROM pa_billing_extensions
         WHERE name = p_billing_extension_name ;

Line: 193

        SELECT project_id
          INTO l_project_id
          FROM pa_projects_all
         WHERE segment1 = p_project_number;

Line: 206

        SELECT task_id
          INTO l_task_id
          FROM  pa_tasks
         WHERE  task_number = p_task_number
	 AND    Project_ID  = l_project_id; -- Added for Bug 2675566

Line: 299

        SELECT project_id
          INTO l_project_id
          FROM pa_projects_all
         WHERE segment1 = p_project_number;

Line: 313

        SELECT task_id
          INTO l_task_id
          FROM  pa_tasks
         WHERE  task_number = p_task_number
	 AND    Project_ID  = l_project_id; -- Added for Bug 2675566

Line: 408

        SELECT project_id
          INTO l_project_id
          FROM pa_projects_all
         WHERE segment1 = p_project_number;

Line: 421

        SELECT task_id
          INTO l_task_id
          FROM  pa_tasks
         WHERE  task_number = p_task_number
	 AND    Project_ID  = l_project_id; -- Added for Bug 2675566

Line: 516

        SELECT project_id
          INTO l_project_id
          FROM pa_projects_all
         WHERE segment1 = p_project_number;

Line: 529

        SELECT task_id
          INTO l_task_id
          FROM  pa_tasks
         WHERE  task_number = p_task_number
	 AND    Project_ID  = l_project_id; -- Added for Bug 2675566