APPS.RCV_DEBIT_MEMO_NOTIF SQL Statements

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

Line: 38

   receiver. commenting the below selection of employee_id from rcv_transactions
   and getting the same from po_headers as below.
*/
        x_progress := '010';

Line: 43

         select shipment_header_id,
--                employee_id,   -- Bugfix #4698050
                quantity,
                po_header_id
         into   x_ship_id,
--                EmployeeId,    -- BUgFix 4698050
                Quantity,
                x_po_header_id
         from rcv_transactions
         where transaction_id = x_transaction_id ;

Line: 56

         select receipt_num
         into ReceiptNum
         from rcv_shipment_headers
         where shipment_header_id = x_ship_id;

Line: 66

         select segment1,agent_id  -- BugFix 4698050
         into PONumber,EmployeeId  -- BugFix 4698050
         from po_headers_trx_v
         where po_header_id = x_po_header_id;

Line: 73

         select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;

Line: 132

	  select count(*)
	  into   x_wf_created
	  from   wf_items
	  where  item_type = ItemType
	  and  item_key  = ItemKey;

Line: 236

      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);