DBA Data[Home] [Help]

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 Bug 16816725
	          FROM pa_tasks_expend_v
                 WHERE task_id = p_task_id
                   AND project_id = p_project_id;
Line: 126

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

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

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