APPS.OE_PAYMENT_ASSURANCE_WF SQL Statements

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

Line: 56

      SELECT 'Y',
             ool.header_id,
             ool.ORDER_SOURCE_ID,
             ool.ORIG_SYS_DOCUMENT_REF,
             ool.ORIG_SYS_LINE_REF,
             ool.ORIG_SYS_SHIPMENT_REF,
             ool.CHANGE_SEQUENCE,
             ool.SOURCE_DOCUMENT_TYPE_ID,
             ool.SOURCE_DOCUMENT_ID,
             ool.SOURCE_DOCUMENT_LINE_ID
      INTO   l_exists_prepay,
             l_header_id,
             l_order_source_id,
             l_orig_sys_document_ref,
             l_orig_sys_line_ref,
             l_orig_sys_shipment_ref,
             l_change_sequence,
             l_source_document_type_id,
             l_source_document_id,
             l_source_document_line_id
      FROM   oe_payments op
            ,oe_order_lines_all ool
      WHERE  op.payment_collection_event = 'PREPAY'
      AND    op.header_id = ool.header_id
      AND    ool.line_id = l_line_id
      AND    rownum = 1;

Line: 101

         SELECT
             ool.header_id,
             ool.ORDER_SOURCE_ID,
             ool.ORIG_SYS_DOCUMENT_REF,
             ool.ORIG_SYS_LINE_REF,
             ool.ORIG_SYS_SHIPMENT_REF,
             ool.CHANGE_SEQUENCE,
             ool.SOURCE_DOCUMENT_TYPE_ID,
             ool.SOURCE_DOCUMENT_ID,
             ool.SOURCE_DOCUMENT_LINE_ID
      INTO
             l_header_id,
             l_order_source_id,
             l_orig_sys_document_ref,
             l_orig_sys_line_ref,
             l_orig_sys_shipment_ref,
             l_change_sequence,
             l_source_document_type_id,
             l_source_document_id,
             l_source_document_line_id
      FROM OE_ORDER_LINES_ALL ool
      where ool.line_id = l_line_id;

Line: 176

       OE_Order_WF_Util.Update_Flow_Status_Code
		(p_line_id  		=> l_line_id,
		 p_flow_status_code  	=> 'PAYMENT_ASSURANCE_HOLD',
	 	 x_return_status  	=> l_return_status);

Line: 182

         oe_debug_pub.add('OEXWMPMB: return status from update_flow_status_code '||l_return_status , 3 ) ;