APPS.PA_EXPENDITURE_INQUIRY SQL Statements

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

Line: 75

       select vend.vendor_id,
              cdl.system_reference2,
              vend.vendor_name,
              vend.segment1,
	      cdl.burden_sum_rejection_code
         from po_vendors vend,
              PA_COST_DIST_LINES_ALL_BAS cdl
        where cdl.expenditure_item_id = p_expenditure_item_id
          and cdl.line_num (+)        = 1
/* Added the getNumericString wrapper over systeem_reference1  for bug3158748 */
          and pa_utils4.getNumericString(cdl.system_reference1)  = vend.vendor_id (+) ;

Line: 128

       select expenditure_id into l_exp_id
       from pa_expenditure_items_all
       where
          expenditure_item_id=p_expenditure_item_id;

Line: 133

       select po.vendor_id,po.vendor_name,po.segment1
       into x_vendor_id,x_vendor_name,x_vendor_number
       from po_vendors po
       where
          po.vendor_id=(select vendor_id from pa_expenditures_all exp where expenditure_id=l_exp_id);