APPS.PO_PROJECT_DETAILS_SV SQL Statements

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

Line: 66

                SELECT task_number
                  INTO x_task_num
                  FROM pa_tasks
                 WHERE task_id = p_task_id
                   AND project_id = p_project_id;

Line: 125

             SELECT project_id, task_id
             INTO   p_project_id, p_task_id
             FROM   po_distributions
             WHERE  po_distribution_id = p_po_distribution_id;

Line: 134

             SELECT project_id, task_id
             INTO   p_project_id, p_task_id
             FROM   po_req_distributions
             WHERE  distribution_id = p_req_distribution_id;

Line: 147

             SELECT project_id, task_id
             INTO   p_project_id,p_task_id
             FROM   oe_order_lines
             WHERE  line_id = p_oe_order_line_id;